Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table, calculated expression

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 ?

ABNb
actu 1X12
50,00%
Y4
-86,67%
Total actu 116
actu 2X8
0,00%
Y30
0,00%
Total actu 238
Total54
Thx for coop
2 Replies
Not applicable
Author

Something like this.

Not applicable
Author

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

.