Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Partner - Creator
Partner - Creator

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