James Kipling | Answers

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions

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

View Question
1 Vote Selected

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

View Question
1 Vote

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

View Question
1 Vote Selected

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

View Question
0 Votes

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

View Question
0 Votes

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

View Question
0 Votes

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

View Question
0 Votes

This will feature in the 2019 release of Quantrix.

View Question
0 Votes Selected

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

View Question
0 Votes
Load more answers