Discussion board where members can get started with Qlik Sense.
I have data like:
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.
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
 Mixing Standard and Synthetic Dimensions in the same Table