Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

paisleymike
New Contributor III

Change Excel Pivot table to Qlik Sense

Hello

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

=Count(name)/Count({1}name)

But this gives the percentage compared to the complete total not the total from the filtered selection

Is there a way to correct this

Pivot table

Column - Category

Row - SIMD Decile

Capture 5.PNG

thank you

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: Change Excel Pivot table to Qlik Sense

Try

Count(name)/Count( ToTAL name)

1 Reply
shraddha_g
Honored Contributor III

Re: Change Excel Pivot table to Qlik Sense

Try

Count(name)/Count( ToTAL name)

Community Browser