topic Re: MonthYear Selections in QlikView

MonthYear Selections

sunilkumarqv — Wed, 19 Feb 2014 07:47:32 GMT

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

Re: MonthYear Selections

Wed, 19 Feb 2014 08:30:50 GMT

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

Re: MonthYear Selections

MK_QSL — Wed, 19 Feb 2014 09:01:02 GMT

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

Re: MonthYear Selections

sunilkumarqv — Wed, 19 Feb 2014 09:51:16 GMT

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

Re: MonthYear Selections

MK_QSL — Wed, 19 Feb 2014 09:54:04 GMT

Can you post your QVW with DUMMY data?

Re: Re: MonthYear Selections

sunilkumarqv — Wed, 19 Feb 2014 12:04:09 GMT

Check the atached File

Re: MonthYear Selections

MK_QSL — Wed, 19 Feb 2014 12:09:10 GMT

Like this?