Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jfung148
Creator
Creator

Sorting on Pivot Table

hello

this is a weird question but how do I sort on a pivot table for a specific dimension

in the example below...

there a dimensions that must be listed 1st/2nd/3rd but I need to sort by the 4th column.. (3fabusage)

I cant move the sort up and down like I could with the other types..

so how do I sort by the 4th columns value but leave it on the 4th column?

thanks

4 Replies
nakul1001
Creator II
Creator II

There are some limitations while sorting when it comes to a pivot table. One way of doing this perhaps will be by selection the check box Expression  (in the Sort tab) and then in the field, create one expression for your dimension: 3fabusage . Such that it sorts based on the values in 3fabusage

jfung148
Creator
Creator
Author

hi

I tried this it doesn't seem to work

I did it for the fabric delivery and its not grouping by the delivery and sorting by that

thanks

johnw
Champion III
Champion III

So I gather that your first four dimensions are all 1:1? How about adding a sort expression of 3fabusage to the first dimension?

marcus_sommer
MVP & Luminary
MVP & Luminary