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

    Change Excel Pivot table to Qlik Sense

    Michael Graham



      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


      Pivot table

      Column - Category

      Row - SIMD Decile



      Capture 5.PNG



      thank you