Month-on-Month comparison

[#1]

Hi,

I would like to calculate the Month-on-Month variant in the pivot table I created.

How should I go ahead doing this?

[jonathandienst]

Hi

Ideally, you will have a month sequence number in your calendar (lets call it MonthSeq), defined like:

     Year * 12 + Month  (where Year and Month are the respective fields from your calendar)

Then month on month would look something like:

     Sum({<MonthSeq={"$(=Max(MonthSeq))"}>} Amount) - Sum({<MonthSeq={"$(=Max(MonthSeq)-1)"}>} Amount)

HTH

Jonathan

[jonathandienst]

If you are making selections on Month or Year, then the set expressions should be:

{<MonthSeq={"$(=Max(MonthSeq))"}, Year, Month>}

{<MonthSeq={"$(=Max(MonthSeq)-1)"}, Year, Month>}

to override these selections and only use the MonthSeq filter.

[#4]

Im trying to attach my qvw, but it is 300mb. how do I attach a smaller qvw in order to show what im trying to achieve?

[kamalqlik]

Hi Gerald ,

Please make restriction on particular field ....

1) Either take data for two month only

2) For particular Procuct Code etc

in where Clause and then upload your QVW. Than only I can look after your problem.

Regards

Kamal

[#6]

Hi,

attached is my qvw. what I would like to do is firstly show the M-O-M change, and then the Y-O-Y change next to that, as a percentage,

[kamalqlik]

please upload it again ....As it is showing error while downloading

[#8]

Here you go, uploaded again.

[kamalqlik]

Hi Geral Month on Month Comparison ....

I understand like this for example we are in March-2015 than you want the comparison for this month and previous month...

and so on...

Please clarify your requirement little bit more

Regards

Kamal

[jpenuliar]

Hi Gerald,

here's a good example (with other tips) by Lee Mathews

Qlikview how to:

http://community.qlik.com/docs/DOC-5486