topic Pivot table, calculated expression in QlikView

Pivot table, calculated expression

Thu, 15 Jul 2010 16:59:16 GMT

New QV user, I need to add a % in a pivot table based upon the same dimension "A" with a specific value.

Below a .qvw for ex. My need is to have "actu 1 / actu 2" using Nb as ind.

What is the formula ?

Thx for coop

Thu, 15 Jul 2010 19:38:30 GMT

Something like this.

Fri, 16 Jul 2010 09:59:42 GMT

More or less. But in the formula, one condition is based on the B dimension (value X and Y) and the result is wrong for "Y" value :

actu 1/ actu 2 = -86,57 % for Actu 2, Y in the pivot table you send me back and this result should be in Actua 1, Y (=> 4/30-1).

Hope you can help me .

Philippe