3 Replies Latest reply: Dec 27, 2017 6:38 PM by Luis Madriz RSS

    Qliksense Pivot table sorting value based on measure

    Prashant Sancheti

      How we can sort a pivot table based on measure value.



      i have requirement where i need to sort a table based on descending order of measure based on value in di,mension.



      for ex : I have DIm1 , Dim2 as Row, Dim 3 as Column and sum(exprn) as measure


      now i need to sort the pivot table based  on 2 condition


      1 )  Dim 3 having one value for ex A


      2) Entire table need to be sorted based on Descending value of Measure (sum(exprn)) for "Dim 3 value A"