Year over Year (YOY) comparison based on Dimensions

[#1]

Hey!

I'm trying to create a Pivot Table which show the actual (Real) and planned (Plano) values, as well as their comparisons -  for some parameters. The parameters are calculated expressions, whereas the distinction between Real and Plano - and hence their comparisons - are the dimension of my table. The following picture shows what I WANT to create (the last two collums are the comparisons).

So far this next picture is what I HAVE, where Real 14/15, Real 13/14 and Plano 14/15 are the components of the Plano/Real dimension.

Could someone help me on how to calculate the comparison collunms, based on the table I have already. Btw, I want the comparison collumns to be on the same "level" as the other collumns.

Thanks!

[Gysbert_Wassenaar]

Can you post a qlikview document that demonstrates the problem?

[#3]

Here you go!

I used only 3 parameters (lines), but it doesn't make any difference since what I want to compare are the columns (Real 14/15 over Real 13/14 and Real 14/15 over Plano 14/15)

[Gysbert_Wassenaar · Accepted solution]

See attached example for a possible approach.

[#5]

Please explain the X in the inline statement? What does the D,N,V stand for and what is the point?

I am trying to tabulate a list of KPIS, and include the mom, yoy, mtd, and a trendline.

[Gysbert_Wassenaar]

The X field is just to categorize the records so I know how to use the values.

V: use the value as it is

N: use the value as numerator in the expression

😧 use the value as denominator in the expression

[jonathandienst]

Neat!

[#8]

Thank you very much for the help Gysbert! But is there anyway you could make this accessible on the Personal edition?

[#9]

Btw, I managed to open the QVW on a friend's pc (I'm using a PE version and cannot open documents from other users anymore) but the table shows "Allocated Memory Exceeded".

Do you know what that might be and how I can solve it?

Thank you once again!

[Gysbert_Wassenaar]

Make sure the machine has enough ram available. About 25 MB should be enough for the example I posted. If that's not the problem then try downloading the document again. Perhaps it got corrupted the first time you downloaded it.