Tahir | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Post Type Selectors
Answers
Questions
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
Commented on a post

I am glad I could help you. This could be relevant to anyone who runs script on large number of calculated cells. Good luck with your model!

April 5, 20232
Posted an answer
Comment/uncomment all formulas on a matrix using script?

Hi Jeffc, Use this script: |Matrix1|.formulae.each {allFormulas -> allFormulas.text = "//" + allFormulas.text } Hope this helps, Tahir

April 3, 20235
Received an upvote
October 11, 202210
Received an upvote
May 17, 202210
Posted an answer
feature request – automatic item selection on linked matrices

Hi Olaf, in the menu go to View then check Synchronize Views. This will synchronize filter tray items across all your matrices. You will have the same item selected in filter area in all matrices and views....

April 13, 20225
Asked a question
New $RoleName variable

Have you tried new $RoleName? This video shows practical usage of Role Names in Quantrix Modeler and Qloud. This feature can save your time because you do not need to create a separate matrix view for...

March 11, 20222
Commented on a post

Nice job!

October 6, 20212
Asked a question
A new way of tracking changes in Quantrix

Hi, We have a new post in Quantrix Europe blog about how to improve model audit and ensure accuracy of entered data. The idea is to see all changes directly on the matrix and even to filter by date and...

October 5, 20212
Received an upvote
September 22, 202110
Posted an answer
Show Cell Indicators in the Qloud

Thank you, it is a good suggestion. I wish Quantrix has some kind list of improvements online, where we can add our suggestions and everyone can vote for them.  There are many things which can be improved...

September 1, 20215
Load More