Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
in qlik sense I have created this graph that measures a rolling of 24 months.
I would like to see only 12 months. If I insert the limitation in the x axis it recalculates the values.
In qlik view there was the possibility to set the value of the graphs scrolling
Is it possible in qlik sense?
Thank you
If your Year-Month is a numeric field, you can try using calculated dimension:
In the table object > add columns > dimensions > click on the fx to open the expression editor, try this as the YearMonth dimension:
=if(aggr(rank(YearMonth),YearMonth)>5,null(),YearMonth)
If Year-Month is a text, try this:
=if(aggr(rank(date#(Datestamp,'YYYY-MM')),date#(Datestamp,'YYYY-MM'))>5,null(),date#(Datestamp,'YYYY-MM'))
Thanks for your reply.
i need to see only 12 months (though the measure it's on 24 months rolling).
The display should look like the bar chart (12 months), but I would like to use the line chart