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

[Anonymous]

Hi All,

I have data like:

Calendar Month	Sales Value
CM200001	240
CM200002	300
CM200003	100
CM200004	678
CM200005	345
CM200006	789
CM200007	256
CM200008	789
CM200009	310
CM200010	560
CM200011	500
CM200012	546
CM200101	789
CM200102	222
CM200103	333
.....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.

[lcontezini]

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