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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
sarfaraz_sheikh
Contributor III
Contributor III

Regarding sort for Total

Dear all,

I am using three dimensional pivot table i want to sort the list Total wise for dimension which i want.

How i can achive the same ...little bit i am confused in that.

Qvw and screenshot  is also attached here for your refrence.

Sarfaraz


5 Replies
tyagishaila
Specialist
Specialist

which total wise sorting you need?

There are two totals 1 is column and another is Total of pivot table()

sarfaraz_sheikh
Contributor III
Contributor III
Author

Hi Shaila,

I want column wise...

Sarfaraz

avinashelite

use the total expression in the sort tab expression this will do:

please find the attachment for the solution.

sarfaraz_sheikh
Contributor III
Contributor III
Author

Dear Avinash,

I want the column wise total to be sorted ....that is my requirement.

Sarfaraz

nigel987
Creator II
Creator II

Hi, did you find a solution for this yet?