how to sort in pivot tables on groups and subgroup... - Qlik Community

vikasmahajan · ‎2012-03-08

Dear All,

How to sort in pivot tables on groups and subgroups on numeric values as well as on a-z alphabetic order.

Thanks

Vikas Mahajan

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Anonymous · ‎2012-03-08

Hi

Using the sort expression you can sort your pivot table.

In the sort expression you can specify your sort order like numeric , text.

If you want to sort some specific manner means you can create the sort order variable for that particular field.

like Country SortOrder

A 1

B 2

C 3

You can mention this order in inline in script

Then you can use this sortOrder in sort exprssion

Regards

how to sort in pivot tables on groups and subgroups