topic Re: Last 12 months in QlikView

Last 12 months

qliktech_uk — Wed, 20 Sep 2017 13:01:54 GMT

Hi,

I have extracted the data for the last 12 months and now need to do month on month analysis.

If a user selects lets say May 2017, I need to show the data for May and difference from April, ie May - April.

So do I use GetFieldSelections and then use Addmonths(month, -1)?

In another table I need to show a trend as well, so to sort the data from last month to the current month, how would I sort it?

thanks.

Re: Last 12 months

Anil_Babu_Samineni — Wed, 20 Sep 2017 13:16:46 GMT

May be this?

For May

Sum({<MonthName = {'$(=Max(MonthName))'}>} Sales)

For May - April

Sum({<MonthName = {'$(=Max(MonthName))'}>} Sales) -

Sum({<MonthName = {'$(=AddMonths(Max(MonthName),-1))'}>} Sales)

Re: Last 12 months

mostwanted123 — Wed, 20 Sep 2017 13:24:55 GMT

Try this,

Sum({<MonthName = {"$(=Max(MonthName))"}>} Sales) -

Sum({<MonthName = {"$(=AddMonths(Max(MonthName),-1))}>} Sales)

Regards,

Pratik

Re: Last 12 months

qliktech_uk — Wed, 20 Sep 2017 14:00:20 GMT

Thanks for your reply. Shouldnt the months be ordered?

Re: Last 12 months

Anil_Babu_Samineni — Wed, 20 Sep 2017 14:08:35 GMT

Means

Re: Last 12 months

qliktech_uk — Wed, 20 Sep 2017 15:21:46 GMT

If I have months from May 17 to Apr 16, I cant use the month numbers as then december would be 12 and I will get the max as December. How would I manage the order of the months

5,4,3,2,1,12,11,10,9,8,7,6

Would I have to create an inline table to define this order. If so wouldnt I have to manually change it for each month?

Re: Last 12 months

Anil_Babu_Samineni — Wed, 20 Sep 2017 15:25:50 GMT

If you use MonthNum / MonthName as Dimension and expression where i gave you can use and check..

Re: Last 12 months

qliktech_uk — Wed, 20 Sep 2017 18:10:34 GMT

thanks Anil. Testing it, will let you know.