In a Qlik Sense pivot table I want to show row percentages adding to 100 % for each row/subgroup.
Here's my pivot table:
The row percent for each year is correct. It sums to 100%.
But I also need a row total of 100% for each Study Programme. That is: in row no 3 (the B-DMD Study Programme) the percent of Females should be 27 / (27+37) = 42,2 % and not the 9,9%.
The percent is calculated with this expression:
SUM(total <STUDYYEAR> ADMITTED)
Solved! Go to Solution.
It works fine in Qlik Sense Desktop, but when I try it on our Qlik Sense Server solution, the percents are the same as my original one.
Could there be any differences on how the Dimensionality() function works i Desktop and Server? Borth are june 2017 release.
I don't see any reasons for differences... can you check if you get different values for Dimensionality() function when you create it as an expression? also do you have more than 2 dimensions here?