MonthYear Selections

[sunilkumarqv]

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

[#2]

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

[MK_QSL]

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

[sunilkumarqv]

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

[MK_QSL]

Can you post your QVW with DUMMY data?

[sunilkumarqv]

Check the atached File

[MK_QSL · Accepted solution]

Like this?