Tahir | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Posted an answer
A-script. Remove all REMs from model formulas

Thank you, SAU, very useful.

December 4, 20205
Posted an answer
How to place Labels inside of a Pie Chart

Great work, SAU! My only concern is what happens when you have many small numbers, which can mix inside the pie. Would be interesting if you explain how you did it.

December 4, 20205
Posted an answer
What is Your Favorite Approach to QuickBooks Integration?

Hi mgandy, just couple of additions to excellent comments from Rich: You can automate this process of importing data from csv and pushing to Sql database if you have a Qloud. You can use automation...

November 30, 20205
Posted an answer
Ask Method scripting

Hi Jason, I am not a scripting expert, but I think it should work for you: def myMessage = "Enter your data" def myInput = ask(myMessage, ["State":String, "Birthday":Date]) def st = myInput.get("State")...

November 30, 20205
Posted an answer
unbalanced ( year and quarter) time line creation

Hi Davood, you may consider creating one matrix with year (1,2) category and another matrix with year(3) and quarter categories. Then you can place and snap them on canvas for reporting.

September 25, 20205
Commented on a post

Thank you for your time and efforts! The whole idea was how to provide restricted access to parts of the same matrix for different users without duplicating matrix or view (especially important when you...

July 20, 20202
Commented on a post

Very interesting experiment. I was also surprised by such a long loading time of my less that 1mb file on the computer with the latest hardware. I had to split the model. Of course, loading the model on...

July 20, 20202
Commented on a post

Thank you!

July 20, 20202
Commented on a post

Interesting. Yes, the problem is when new item is added, unfortunately we have to add switch manually which is not optimal

July 20, 20202
Posted an answer
Data slices in the QM

Interesting. Yes, the problem is when new item is added, unfortunately we have to add switch manually which is not optimal

May 7, 20205
Posted an answer
A dynamic distribution of the budget period onto three parts

Looks interesting, please share your model.

February 19, 20205
Posted an answer
A Doughnut Chart. Demo of QM’s possibilities

Great idea! Would be good if you share how you did it. Here is my workaround for doughnut chart 🙂

January 22, 20205
Posted an answer
Excel Export

Hi Carlo! I think there is no option to remove it. This information does not appear if you export as csv file. You can open it in excel but then you have layout and format issue. It is done to promote...

January 17, 20205
Posted an answer
The histogram based on two svg-images

James, in original model it is used for data analytics visualization, where user can dynamically form a question and receive an answer in form of ranking which includes budget and actual data. There is...

August 28, 20195
Posted an answer
The histogram based on two svg-images

Thank you SAU for sharing and referencing to my video. This is a way to bring more appealing visuals to canvas with own icons, since existing data visualization tools in Quantrix are limited.

June 20, 20195
Received an upvote
June 4, 201910
Posted an answer
Copy values of one item to another across all matrices

After extensive reading, learning and trying I have figured out how to write this script. If anyone interested in accessing items and categories across the whole model via script with dynamic input, please...

June 3, 20195
Posted an answer
Copy values of one item to another across all matrices

This model is an example. Real models are bigger. Data source for Plan is manual entry.

June 2, 20195
Posted an answer
Copy values of one item to another across all matrices

Hi SAU. I meant from May 2019 until the end of the year. There are many matrices and many model templates where this operations is required. Those are all assumptions which should be simply populated again....

June 2, 20195
Asked a question
Copy values of one item to another across all matrices

Hi, I am trying to achieve the following: Copy values of "Plan" item to "Revised Plan" item (model is attached). The script should take given particular year and month and apply to this year and this months...

June 2, 20192
Load More