Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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
New Contributor III

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
Valued Contributor II

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
Esteemed Contributor

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

Community Browser