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"