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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sorting of dimension by expression

helllo

i use qlikview 11 in that i have craete one pivot  table which has dimesions of  customers and in expression side  salesvalue.

I want to sort customer by exp salesvalue .salesvalue is at exp side.

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

On the Sort tab of the properties window select the top dimension and enable the Y-value option for Sort by. That will sort the pivot table using the values of the first expression of the chart.


talk is cheap, supply exceeds demand
Not applicable
Author

Thank u sir,

     it work for only first exp.in my case i have to sort based on selection i.e

i have filter "by qty" ans "by sales". if i click on by qty then sales qty should sort and same for by sales.

any suggestion .

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See the examples in this discussion


talk is cheap, supply exceeds demand