Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sorting the dimension in pivot table

Take a look at my pivot table below (example only).

Job is one of my dimensions and it diplays its contents as indicated below (Type3, Type 2 etc.).  How can make Type3, Type2 display in ascending order. Example: Type1, Type2, Type3, Type4

    Testname              Job      Type3          Type2          Type4          Type1

               AN                                    9               9                    9               9

               BN                                    7               7                    7               7

               CN                                    6               6                    6               6

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Set the sort order of the Job dimension to Text A->Z on the Sort tab of the properties window.


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Nicole-Smith

On Sort tab, you should be able to choose the dimension and do a sort by text.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Set the sort order of the Job dimension to Text A->Z on the Sort tab of the properties window.


talk is cheap, supply exceeds demand
Not applicable
Author

So Job is not one of the options that is displayed within sort, so this is what I did, within sort, select any one of the dimensions, in my example above I would select Testname and add expression =job then select ascending order and text (A-Z).

Not applicable
Author

Thank you for response

Not applicable
Author

Thank you for your response