Tahir | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Post Type Selectors
Answers
Questions

Welcome to the Quantrix Answers Community! This is a place for Quantrix users from around the world to share their questions, knowledge, and ideas. If you are posting a question, please include any accompanying information that might be useful to the reader (for example, a demo model or screenshot). Do not include any confidential information in your posts and remember that model attachments must be zipped. If your question is answered, please provide feedback! Providing feedback can help future users understand what’s worked. Thank you for being part of the Quantrix Community!

Please Note: A Quantrix team member will review new questions before publishing to the public. We hope this will reduce unwanted posts on our site.

Posted an answer
copy paste values problem

Hi Marie, try this script: |Matrix1::B|.items.each{ destinationCat-> if(|Matrix1|.getSelection(destinationCat, |Matrix1::A2|).value == null){ |Matrix1|.getSelection(destinationCat, |Matrix1::A2|).value...

May 16, 20245
Posted an answer
copy paste values problem

Hi Marie, the easy way to copy values from A1 to A2 (even if A2 has some values) would be this script: |Matrix1::A2|.values = |Matrix1::A1|.values Tahir

May 15, 20245
Posted an answer
Filtering a Category via Scripting

Hi Montecristo, I am not sure if you need script for that. I assume you would like to be able to choose which group to filter. To achieve group filtering you can use expression in cell filtering and constrain...

May 10, 20245
Posted an answer
Allow for expressions in Item Filter

Hi Gilbert, You can use expression in cell filter of a table view to achieve this. You can even go further and use sliders on canvas to dynamically change start and end date of the chart. See a demo below....

May 9, 20245
Posted an answer
List all matrices in a folder

Hi, there is no way to manipulate folders via script. I think one workaround would be to have some tag (letters or numbers) in the name of import matrices, then run matrices loop to find matrices that...

April 25, 20245
Received an upvote
April 8, 202410
Posted an answer
Qloud Losing Formatting

Hi Mark, I think the reason of all of these problems is using lines. Because of that I avoid using lines. One workaround, albeit time-consuming and not scalable, would be putting matrix several times on...

March 23, 20245
Received an upvote
February 16, 202410
Posted an answer
Sum by group in the same matrix

Hi Marie, sorry, it is a bit hard to answer your question without a screenshot. You probably mean group of items (not categories). If you like to sum group of items with values of products, select this...

February 15, 20245
Posted an answer
Script code to show message at the end of run

Hi Robert, use alert("Export complete") Tahir

February 15, 20245
Received an upvote
November 2, 202310
Posted an answer
Reorder items based on multi column sort

Hi jefcc, Yes, it is possible to reorder items based on values via script. See basic version below. It should be clear that in a sorted matrix, Quantrix sees only original (unsorted) item position (index)....

November 1, 20235
Received an upvote
August 1, 202310
Commented on a post

I am glad that I could help you. Good luck with your Quantrix models!

July 15, 20232
Received an upvote
July 15, 202310
Posted an answer
reference matrix name in a formula

Hi Bristly, I think I found a solution for you. As you see on the screenshot I used indirect function to make a matrix name variable. You do not need to change this formula when you add a new ticker, it...

July 14, 20235
Received an upvote
July 13, 202310
Received an upvote
July 13, 202310
Posted an answer
reference matrix name in a formula

Hi Bristly, it is a good question. I understand the pain of doing it one-by-one. The best way would be to find a single source or a single link to all of your tickers. But if you do no want to pay for...

July 13, 20235
Posted an answer
sum(summary()) for groups with varying number of items

Hi lyledp, one way to solve this problem would be adding a new item to calculate cumulative values for each group with a single formula. Then you will not need sum summary items and formulas at all. Let...

July 9, 20235
Load More