topic Change precent between 2 dimensions in QlikView

Change precent between 2 dimensions

m4u — Wed, 13 Apr 2011 20:54:29 GMT

Hi all,

I attached an image about my question.

i have a report (pivot table) with some dimsnsions, my last dimensions is the year.

i need to to add another row under the 2 years, which will show the change precent between the 2 last years.

how could i do that? is the only way - to add an new year dimension, which will contain the different between them?

thanks

Change precent between 2 dimensions

Oleg_Troyansky — Wed, 13 Apr 2011 22:01:24 GMT

Well, there is a "tricky" way of doing it - Add a subtotal and replace the definition of the total by the formula for a difference between the years. It only works if you always have only 2 years though.

In a more "traditional" way, you'd need to create a Dimension that has three values - "2010", "2011", "Diff" and structure each Expression accordingly...

...??????

Change precent between 2 dimensions

m4u — Wed, 13 Apr 2011 22:09:01 GMT

Hi .

very nice ideas

but how can i change the sub total formula?

Many thanks

??????

Change precent between 2 dimensions

m4u — Wed, 13 Apr 2011 22:10:27 GMT

shoud i use a calculated dimensions and dimensionality()?

Change precent between 2 dimensions

Oleg_Troyansky — Wed, 13 Apr 2011 22:40:54 GMT

Well, n this case - one or the other. With Claculated Dimensions, you don't need to alter the subtotal formula.

With Dimensionality, you don't need Synthetic dimensions, you can simply check for Dimensionality() = 0 (if it's the overall total) or 1, and then use one calculation or another.

As a warning - I wanted to use Dimensionality recently, and I expected to see 1 for the first sub-total and 2 for the detailed cell, and I got 1 for both, which made this approach useless. So, check your Dimensionality before you spend too much time on the expressions.