2 Replies Latest reply: Jan 14, 2017 11:06 AM by Girirajsinh Vaghela RSS

    How to Sort Second Dimension in Pivot Table of Qlik Sense

    Vivek Kalekar

      I am having a Pivot table which has two Dimensions Namely CustomerID and ProductName and one Measure as Count(OrderID). Now when is sort these dimensions based of on count of Order ID(I am using expression option to sort these dimensions & expression is Count(OrderID) ) ,I am able to sort the First Dimension i.e. Customer ID but when I expand this Dimension to see ProductName ,values don't appear to be sorted.

       

      Can anyone suggest me how to achieve this.?

       

      Thanks in advance.

       

      -VIVEK

      Dim1.PNGDim2.PNG

       

      See In above screenshot, In First screen I am able to sort CustomerID based on count of orders but when I Expand customerID 1, Product names don't appear to be sorted according to orders.