Last 12 months in a Line Chart based on Month Number

[#1]

Hi there,

I've had a search of the forum but couldn't find any answers that worked for me.

I'm using QlikSense and I'm simply looking to create a Line Chart which shows monthly sales for the current month (max(MonthNo) and the previous 11 months sales shown as different points on the graph.

Any help would be much appreciated.

Cheers

Paul

[sunny_talwar]

All you need is set analysis on your monthyear or date field... check here

Dates in Set Analysis