topic Re: Previous Month & Current Month for Rolling Expression in QlikView

Previous Month & Current Month for Rolling Expression

ankitg4688 — Mon, 25 Sep 2017 19:44:40 GMT

Hi,

I want to show Previous Month value and Current Month value in same hover box on current month. I have to roll both the expression for 13 Months. So every time when I hover on specific month it will show me Current and Previous Month values.

I chose Combo Chart for this. There is another Rolling month expression which creates line. Below two expressions will show details in hover box.

My Rolling Month expression for Current Month is

count(distinct { $< YEAR_MONTH= {" >= $(=date(addmonths(date(date#(Max(YEAR_MONTH),'YYYYMM'),'YYYYMM'), -12),'YYYYMM' )) =< $(=date(addmonths(date(date#(Max(YEAR_MONTH),'YYYYMM'),'YYYYMM'), - 0),'YYYYMM' ))" },

Type=1 > } Products )

My Rolling Month expression for Previous Month is

count(distinct { $< YEAR_MONTH= {" >= $(=date(addmonths(date(date#(Max(YEAR_MONTH),'YYYYMM'),'YYYYMM'), -13),'YYYYMM' )) =< $(=date(addmonths(date(date#(Max(YEAR_MONTH),'YYYYMM'),'YYYYMM'), - 1),'YYYYMM' ))" },

Type=1 > } Products )

But my second expression doesn't give value as needed. Can somebody help?

Thanks for sharing the knowledge.

Regards,

Ankit

Re: Previous Month & Current Month for Rolling Expression

vvira1316 — Mon, 25 Sep 2017 20:13:56 GMT

Hi Ankit,

Will you be able to share sample data/app?

BR,

Vijay

Re: Previous Month & Current Month for Rolling Expression

ankitg4688 — Mon, 25 Sep 2017 20:53:17 GMT

Hi Vijay,

Thanks for your response. Sorry but I can't share sample data or app for this.

Br,

Ankit

Re: Previous Month & Current Month for Rolling Expression

vvira1316 — Mon, 25 Sep 2017 21:00:56 GMT

See if either of the following link will help

https://community.qlik.com/thread/272036

https://community.qlik.com/thread/103489

Re: Previous Month & Current Month for Rolling Expression

Anil_Babu_Samineni — Tue, 26 Sep 2017 01:59:23 GMT

This part may be like below

count(distinct { $< YEAR_MONTH= {" >= $(=date(addmonths(date(date#(Max(YEAR_MONTH),'YYYYMM'),'YYYYMM'), -13),'YYYYMM' )) <= $(=date(addmonths(date(date#(Max(YEAR_MONTH),'YYYYMM'),'YYYYMM'), - 1),'YYYYMM' ))" },

Type={1} > } Products )

Re: Previous Month & Current Month for Rolling Expression

ankitg4688 — Tue, 26 Sep 2017 18:56:06 GMT

Hi Vijay,

Thanks for your response. First link will give me Aggregated value from start till current month. However, I want only that specific Previous Month's value and show it in current month's hover box and continue to roll for 12 months. Any other idea?

gwassenaar‌, vishsaggi‌ Could you please also suggest on this? This is quite urgent. Many Thanks.

Thanks for sharing the knowledge.

Ankit

Re: Previous Month & Current Month for Rolling Expression

ankitg4688 — Tue, 26 Sep 2017 18:57:35 GMT

Hi Anil,

Thanks for correction. Sorry for typo error.

Thanks for sharing the knowledge.

Ankit