Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Year over Year (YOY) comparison based on Dimensions

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).

Forum 2.PNG

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.

Forum 1.PNG

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!

Tags (3)
1 Solution

Accepted Solutions

Re: Year over Year (YOY) comparison based on Dimensions

See attached example for a possible approach.


talk is cheap, supply exceeds demand
12 Replies

Re: Year over Year (YOY) comparison based on Dimensions

Can you post a qlikview document that demonstrates the problem?


talk is cheap, supply exceeds demand
Not applicable

Re: Year over Year (YOY) comparison based on Dimensions

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)

Re: Year over Year (YOY) comparison based on Dimensions

See attached example for a possible approach.


talk is cheap, supply exceeds demand
Not applicable

Re: Year over Year (YOY) comparison based on Dimensions

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.

Re: Year over Year (YOY) comparison based on Dimensions

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

D: use the value as denominator in the expression


talk is cheap, supply exceeds demand
MVP
MVP

Re: Year over Year (YOY) comparison based on Dimensions

Neat!

Not applicable

Re: Year over Year (YOY) comparison based on Dimensions

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

Not applicable

Re: Year over Year (YOY) comparison based on Dimensions

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!

Re: Year over Year (YOY) comparison based on Dimensions

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.


talk is cheap, supply exceeds demand
Community Browser