Printing selected columns over years

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
478 viewsTips and Techniques

I have a matrix that overlaps several years.  How do I print only the next six months of columns?  i.e. September 2018 – February 2019.  I am using a timeline with years, quarters and months.

Answered question

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 – Display) based on an expression (You could throw the whole calc matrix formula into the expression if you wanted to, but this way you can use the display indicator elsewhere to filter the views as necessary)
I hope this helps.

Answered question

Latest Questions

Complex Queries in Quantrix 1 Answer | 0 Votes
DataLink / JDBC / EXEC 3 Answers | 0 Votes
Wrong calendar calculations 1 Answer | 0 Votes
Script to delete rows 3 Answers | 0 Votes