1 Reply Latest reply: Nov 27, 2017 5:52 AM by Shraddha Gajare RSS

    Change Excel Pivot table to Qlik Sense

    michael graham

      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