rlopez | 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.

Received an upvote
June 6, 202110
Answer was selected as best
January 11, 201910
Received an upvote
January 11, 201910
Received an upvote
October 29, 201810
Answer was selected as best
Multiple Selection of Categories

ShriShank, The filter capabilities that you describe don't quite work the same way in Quantrix as they do in Excel. Perhaps this video Episode 190 of the Quantrix Authority (https://www.youtube.com/watch?v=B6zxfvRgWSE)...

October 29, 201810
Answer was selected as best
DataLink and other Scripts

tawanda, This is how you would delete the blank rows assuming that Category A of Matrix2 is in the Row position. //DeleteNonBlankRecordInCategory //By rlopez 10/15/2014 //Begin the For Each Loop |Matrix2::A|.items.each...

June 12, 201810
Answer was selected as best
IRR function

vishnuyarlagadda, I think I figured it out using sublist(), first(), last(). See the attached model and the Answer Item formula. It solved for Cash1. Let me know if this is what you were looking for....

June 12, 201810
Answer was selected as best
Filters

Vishnuyarlagada, I think this question can be answered by this post "Copy Data from Datalink to New Matrices" viewtopic.php?f=19&t=1034&p=3333#p3333"

June 12, 201810
Answer was selected as best
USING AS or Select

vishnuyarlagadda, Attached is a model with three different solutions. Monthly Consumption Select Monthly Consumption Using As Monthly Consumption Datalink As far as best practices, there are multiple...

June 12, 201810
Answer was selected as best
Sum across all subsequent items in a Year:Month Timeline

Jlin, In regards to your first question formula B5: I too have received a similar error when trying to do a running sum. Here is the explanation from Quantrix that I received on this question. [quote:ovcd8n2d]Quantrix's...

June 12, 201810
Answer was selected as best
Recursion [PREV]

the answer is [PREV-n] n being the number of years minus 1 you want to go back. if the year is 2015 and I want to go back 2 years to 2013 it would be [prev-1].

June 12, 201810
Answer was selected as best
Using titles in presentation canvases

Here is the attachment. Rich Lopez

June 12, 201810
Answer was selected as best
Soft Recurrence as an arguments of the Min()

SAU, I would say this is a bug. I've also tested this using the Max Function and the same results. I've tried multiplying by 1 the soft recursion (M1::B[~PREV]*1) no success. Even checking the help...

June 12, 201810
Received an upvote
June 5, 201810
Received an upvote
June 5, 201810
Received an upvote
June 5, 201810
Answer was selected as best
Loop Through and Delete Items

|Matrix1::B|.items.each { if (!|Matrix1|.getSelection(it, |Matrix1::Use|).value.equals(“YES”)) it.delete() } Thanks to the IDBS Support desk on this one. As a note the exclamation point “!” in...

March 26, 201810
Posted an answer
August 16, 20175
Registered
July 27, 201710
Posted an answer
July 23, 20175
Load More