Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have this pivot table (data is scrambled)
Like you can see on the top of the table I have dimension with years which I need to sort by numeric value. But in sort sheet i can not see this dimension. Can anyone help me, please?
Hi,
I think empty space is given as caption for Year and Quarter, just click below your cyclic dimension in Sort tab, your year dimension will be highlighted and select Numeric Value - Ascending.
Hope this helps you.
Regards,
Jagan.
Lucie,
change the chart type: Pivot Table -> Straight Table and you can sort.
BR
Andreas
Hi,
I think empty space is given as caption for Year and Quarter, just click below your cyclic dimension in Sort tab, your year dimension will be highlighted and select Numeric Value - Ascending.
Hope this helps you.
Regards,
Jagan.
Hi,
have a look at below post on how to sort pivot table
http://community.qlik.com/docs/DOC-7220
Regards
ASHFAQ
Hi
Assuming that your year dimension is a field (not a calculated dimension), then you can go to Document Properties | Sort and set the default sort order for the year field.
HTH
Jonathan
Thanks, that's it