4 Replies Latest reply: Aug 12, 2016 7:47 AM by Hannah Lines RSS

    Qlik Sense Pivot Table Date Drop Down not sorting numerically

    Hannah Lines

      Hello, I have a pivot table which has a dimension of "Month" in the format of "Jan 2014." I have it set to sort numerically, but the drop down selection on the pivot table is not sorting. How would I be able to get this list sorted properly?

       

      In the screen shot, the red box shows the drop down values that are not sorted correctly. The blue box shows the rows in the pivot table that are sorted correctly. I would like to sort the drop down values the same as the row values.

      month.jpgmonth2.jpg