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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table Sorting.

Hi Everyone,

I have a Pivot table similar to the one below, i know in pivot table is done only primary and then its dependents.

Capture.PNG

But i need Sorting by column # of calls.

Is it possible to sort in that fashion.

Thanks

Nithin

3 Replies
Umesh
Contributor III
Contributor III

@Hi Nithin,

You can Sort the Expression Column Based on the Y Value.

Please find the document and refer the Sort tab.

Pivot table Sorting.

Thanks

Umesh

Capture.PNG

PradeepReddy
Specialist II
Specialist II

Properties-->Sort--> Choose the dimension--> choose the type of sort do u want...

here, either 'Y-value' or expression 'count(CallID)'

Anonymous
Not applicable
Author

Properties -> Sort Tab -> Priority ->Promote (# Of Call) to top -> Select Asc or Dsc from Numeric Value(Uncheck all other options)

Also dont forget to uncheck all other sorting option of all the Dimension & Measure, you have to sort only with Numeric value of # Of Call..