Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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