Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Highlighted
Umesh
Not applicable

Re: Pivot table Sorting.

@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
Not applicable

Re: Pivot table Sorting.

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

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

balrajahlawat
Not applicable

Re: Pivot table Sorting.

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..