James Kipling | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Posted an answer
The histogram based on two svg-images

Elegant and simple - I love it. Nice job SAU! I hadn't even considered referring to an image in a cell. I thought it may have involved a custom scripted function to call some HTML to display the images...

July 11, 20195
Posted an answer
The histogram based on two svg-images

Tahir/SAU, I'm fascinated by this - how was it achieved? Scripted function? James

July 5, 20195
Received an upvote
April 13, 201910
Posted an answer
Small() and Large() does not take If() as an argument

Hi SAU, Nobody here is deleting any posts or attachments. Perhaps there was an issue with the forum migration to the new platform - I apologize for this inconvenience. Thank you for bringing this behavior...

March 11, 20195
Posted an answer
Linked Category Limit in Matrix??

Hi Josh, Currently there is no way to expand the filter tray area at the top of a matrix however I can suggest a few (non-optimal) workarounds: Collapse other side tabs such as model browser (Shortcut...

January 11, 20195
Answer was selected as best
November 5, 201810
Posted an answer
Data Nav grouping

This will feature in the 2019 release of Quantrix.

November 5, 20185
Received an upvote
November 5, 201810
Answer was selected as best
November 5, 201810
Posted an answer
How to populate descriptor with function

Hi vb, This is certainly possible using a smart timeline category. You can use the function timelinedate() to achieve this. James

November 5, 20185
Received an upvote
Summarise data by a criteria which is in another matrix

Hi, In the Marks by Gender matrix, you can use the following formula as a solution; : = clearerror(average(Marks::)) using Demographics::Gender as Gender skip Average of Course Hope this helps. James

November 5, 201810
Received an upvote
October 30, 201810
Posted an answer
USING AS with source from a multi-dimensional table

In this particular model the following formula will work: Test Cashflow = sum(select('NEW Crop P&L'::Net Cashflow:Sum of Crops,"Y"&#'NEW Crop P&L'::Year,TimeKey::)) Kind Regards, James

October 29, 20185
Answer was selected as best
October 29, 201810
Posted an answer
Open Quantrix Panels via scripting

Hi Nikki, You will have to use the openPerspective(perspectiveName) function and configure the perspectives to include the visibility of the various 'tool panels'. Kind Regards, James

October 29, 20185
Posted an answer
System Configuration for Quantrix

Hi Vishnu, You may wish to check Tools>Options>General. In here you can up the maximum memory allocation for the Quantrix App. Additionally, you may wish to experiment with the various calculation...

October 29, 20185
Posted an answer
Printing selected columns over years

Hi Billy, In the attached model I have used a formula to calculate whether to display a certain month based on various parameters (Display Settings::). I have then added a filter to a view (Data Matrix...

October 29, 20185
Posted an answer
Matrix Size

Hi Shrishank, There is no inbuilt functionality to get this information on a per-matrix basis. As Rich indicated you can easily get this information for the model as a whole. Whilst I am not a scripting...

October 29, 20185
Posted an answer
Greyed out slider on presentation canvas

Hi Billy, Are you able to share a copy of the model for us to diagnose the issue? If you don't want to post it publicly on the community you can email it to me at jkipling@quantrix.com and I will take...

October 29, 20185
Answer was selected as best
How do I constrain output to be zero or positive numbers only?

Wrap the formula with max(0, -your formula here- )

October 29, 201810
Load More