graphs scrolling

[ingpiolo]

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 

[Arthur_Fong]

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'))

[ingpiolo]

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