Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

praveengawande
New Contributor

How to get Selected Month and previous 11 months data in QlikSense

Hi All,

I have data like:

Calendar MonthSales Value
CM200001240
CM200002300
CM200003100
CM200004678
CM200005345
CM200006789
CM200007256
CM200008789
CM200009310
CM200010560
CM200011500
CM200012546
CM200101789
CM200102222
CM200103333
.....so on

Wanted to show : Sales Trend Last Twelve Months .

I would like to have a chart where in user click on calendar month filter (for example CM200101), and qliksense display chart should have CM200101 sales value along with previous 11 months value.

Thanks,

Praveen.

1 Reply
lcontezini
Contributor

Re: How to get Selected Month and previous 11 months data in QlikSense

I've been trough this one before, and you'll solve it using the pick() function.

Take a look at this:

Mixing Standard and Synthetic Dimensions in the same Table

[2] Mixing Standard and Synthetic Dimensions in the same Table

Community Browser