Discussion board where members can get started with Qlik Sense.
I am looking at using a similar pivot table within Qlik sense as I have used in excel
I can crate the pivot table and make the columns and rows correct the only issue is the measure
The table uses the percentages of the total number from each column compared to the complete total
i.e Total is 44 and number within Very Low column is 4 therefore percentage will be 10%
my original idea was to find the percentage by using the expression
But this gives the percentage compared to the complete total not the total from the filtered selection
Is there a way to correct this
Column - Category
Row - SIMD Decile
Go to Solution.
Count(name)/Count( ToTAL name)