shrishank | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Commented on a post

Thank you. Simplest A-Scripts works

July 20, 20202
Commented on a post

The range is from Apr to Sep. I am trying to find out a way to automatically set the range based on month in another matrix.

July 20, 20202
Commented on a post

Yes the range is from Apr to Sep. I am trying to set the range based on another matrix where I can change the month.

July 20, 20202
Posted an answer
Reference Formula

The value for the Apr to Sep range can be based on some calculation nothing specific. They will be based on the requirement. This can be commission, Salary etc

May 2, 20195
Posted an answer
Reference Formula

Yes, the range is Apr to Sep. I am trying to create a separate matrix where I can type the name of the month that would automatically update the change

May 2, 20195
Asked a question
Reference Formula

I am trying to reference month from "Month" matrix but I am getting Syntax error In Calculation Matrix formula : In Forecast, Oct ..Month::Ending Month =" " What am I doing wrong

May 2, 20192
Posted an answer
Script to delete rows

Thank you . Simplest A-Script works

April 1, 20195
Asked a question
Script to delete rows

Hello, I am trying to delete dept Tech and Sub dept C1 from Corp. I wrote the script: |Department::Dept|.items.each { if (|Department|.getSelection(it, |Department::Tech|).value.equals("Tech")) /*Trying...

March 29, 20192
Asked a question
Tableau and Quantrix Connection

I would like to know if there is a way to connect the Quantrix model with Tableau. So, when Quantrix model is update I just refresh the Tableau.

February 15, 20192
Asked a question
How to adjust the value based on Flag

Hello, I am trying to write a formual in consolidated matrix of the model that would pull the value from forecast matrix . So, If I out a flag in Quarter matrix say Q1=1 then it would pull Actual type...

February 14, 20192
Posted an answer
How to delete a row in 2 dimensional Matrix

Thank you for the reply and for sharing the model. The script works. Quick follow up question. If I have to delete rows based on criteria in seperate column do I write the function twice example: |M1::RowLst|.items.each...

February 12, 20195
Asked a question
How to delete a row in 2 dimensional Matrix

Hello, If I have a 2 dimensional matrix : Qtr1   Product Row1   Q1       Tesla Row2   Q2        Ford What command should I write to delete all the rows that have product "Ford" ? Thanks

February 11, 20192
Asked a question
Button Scripting

Hello, I am trying to add a button that would add a of Soft. Version row. I wrote the code |'Software & Version'::'Soft. Version'|.children.create(1) but its giving me error. What am I doing wrong?

August 30, 20182
Received an upvote
July 20, 201810
Posted an answer
Error Message: Issue setting cell value: throwable

Thank you for the reply. I deleted the matrix and recreated a new. This resolved the error.

July 19, 20185
Asked a question
Error Message: Issue setting cell value: throwable

I am trying to edit/update the Matrix (writing Text) on the Qloud. But I get the below error message: How do I resolve this issue?

July 16, 20182
Asked a question
Matrix Size

Is there a way to find the size of matrices within a model?

July 9, 20182
Registered
July 27, 201710