topic Re: Compare two months (Current vs Prior Month) in QlikView

Compare two months (Current vs Prior Month)

Manju11 — Fri, 16 Sep 2022 09:44:36 GMT

I have a data which contains 'Months' of Vehicle for all 5 months (see example below). I also have a process month to select current month in my dashboard. Whenever a user selects a 'month', I intend to show a difference of '+/- Prior Month ' between for the month selected ('current month') and month prior to it ('prior month').

Table: i want data in negative values for prior month and % prior month i want compare current month with prior month (may nd april)

vehicle Jan Feb mar april may +/- prior month , % prior Month

A 10 20 30 40 30 -10 75%

B 5 8 10 15 10 -5 66%

c 6 7 10 15 8 -7 53%

calculation: 30 - 40 = -10 is +/- prior month

30/40*100 = 75% % prior month

i used to show monthly each month data as exp is

=Sum({$<Type={'Sales'},Date=, Process Month={'may '}>}Volume)

Please advice .Thanks

Re: Compare two months (Current vs Prior Month)

BrunPierre — Sat, 17 Sep 2022 12:19:37 GMT

Supposing the Month and Process Month are linked, I'd convert the Month Name to a Number

Num(Month(Date#(Month, 'MMMM'))) as [Process Month]

And then

+/- Prior Month

Sum({$<Type={'Sales'},Date=,[Process Month]={"$(=max([Process Month]))"}>}Volume)

Sum({$<Type={'Sales'},Date=,[Process Month]={"$(=max([Process Month]-1))"}>}Volume)

Re: Compare two months (Current vs Prior Month)

Manju11 — Mon, 19 Sep 2022 08:52:28 GMT

Thanks for your reply, it didn't work. It also returns Zero values.