Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Last 12 months in a Line Chart based on Month Number

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

1 Reply
MVP
MVP

Re: Last 12 months in a Line Chart based on Month Number

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

Dates in Set Analysis

Community Browser