topic Month Trending with the Selections in QlikView

Month Trending with the Selections

Anonymous — Wed, 07 Sep 2016 18:52:27 GMT

Hello everyone,

I'm trying to show the trending for Month in BAR chart. Usually when we select the month from the list box, it will show the particular selected month data only.

My requirement is when I select the Month from the list box, It should show the previous 5 months data along wit current month.

For example If i select the Month-Year as April 2016 then the bar chart should display the trending for April 2016, March2016, Feb2016, Jan 2016, Dec2015, Nov 2015.

Please help.

Thanks,

Rajitha

mrkachhiaimp‌ phaneendra.kunche‌ stalwar1‌

Re: Month Trending with the Selections

sunny_talwar — Wed, 07 Sep 2016 18:55:21 GMT

May be using set analysis:

{<[Month-Year] = {"$(='>=' & Date(AddMonths(Max([Month-Year]), -5), 'MMM YYYY') & '<=' & Date(AddMonths(Max([Month-Year]), 0), 'MMM YYYY'))"}>}

Now I am not sure how you create Month-Year in script, but why is some months complete name (March) vs. others have short month name (Feb)?

Re: Month Trending with the Selections

Anonymous — Wed, 07 Sep 2016 19:13:17 GMT

Sorry all the months have the same format MMM/YY. I'm trying to write this in Calculated Dimension. Is this possible. Please advise?

Re: Month Trending with the Selections

sunny_talwar — Wed, 07 Sep 2016 19:17:05 GMT

I guess, something like this:

If([Month-Year] <= Max(TOTAL [Month-Year]) and

[Month-Year] >= AddMonths(Max(TOTAL [Month-Year]), -5), [Month-Year])

But make sure to ignore selection in [Month-Year] field in your expression. Assuming you have Sum(Sales) as your expression, change it to -> Sum({<[Month-Year]>} Sales)