topic Re: difference on expression in a pivot table in QlikView

difference on expression in a pivot table

Thu, 29 May 2014 16:39:55 GMT

Hi all,

i have a pivot table with one dimension (two value) and several expression calculated on it.

now i want to calculate the difference between the two expression on a third column...

	dimension value 1	dimension value 2	-
expression1	3	5	-2
expression2	80	67	13

do you think it's possible?

thanks in advance, Loris

Thu, 29 May 2014 16:47:01 GMT

Create a new expression:

Dimension value 1 - dimension value 2

boorgura — Thu, 29 May 2014 16:53:17 GMT

I believe it should be a new expression "expression1 - expression2", expression1 and expression2 should be the label names!

PradeepReddy — Thu, 29 May 2014 18:22:52 GMT

I am not clear about the labels i.e dimensions and expressions that you mentioned.

We can achieve this using Before() function.

Before(Sum(Field_A),1)-Before(Sum(Field_B),2)

Fri, 30 May 2014 07:21:07 GMT

I achieved the result in this way:

= if(IsNull(year),before($(pf_immo1),2)-Before($(pf_immo1),1),$(pf_immo1))

i also have to check "show all value" in the options of year dimension

so when it is null it shows the difference between the two value

maybe not so clear but it works!!