Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have chart with monthyears from jan/2011,feb/2011...dec/211,jan/2012,feb /2012..dec/2012 like x-axis if i get selected mar2012 data in chart shows only relavent data of mar/212 and some value in same manner if i get selected that monthyear i.e mar/2012 it should display that monthyear as well as prevoius years of that month as i mentioned monthyears . I will apprecaite any one help out.
Please find below screnshots
Like this?
Sunil,
You will need to use the set analysis.
See a doc I have written on that topic: http://community.qlik.com/docs/DOC-4951
You will find your answer. And this one depends on your data model.
Fabrice
Dear Sunil,
There are many ways to achieve your requirements but better if you would upload your sample file.
The best way to achieve this is by creating Unique ID for each MonthYear in the script by using AUTONUMBER function while creating master calendar.
Kindly upload your sample file or apps.
Thanks
Yes you are write at what i have mentioned but I created some dummy dates Id means dynamically created MonthEndID s its not working on that occasion .only relavent data have values not for Dynamically created Date Id If So
How?
Here Relavent data showing some values other are dynamic Dates
Can you post your QVW with DUMMY data?
Check the atached File
Like this?