Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting data in pivot table with cyclic group

Hello, I have this pivot table (data is scrambled)

SORT.PNG.png

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?

SORT2.PNG.pngSORT3.PNG.png

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

5 Replies
qvwarning
Creator
Creator

Lucie,

change the chart type: Pivot Table -> Straight Table and you can sort.

BR

Andreas

jagan
Luminary Alumni
Luminary Alumni

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.

ashfaq_haseeb
Champion III
Champion III

Hi,

have a look at below post on how to sort pivot table

http://community.qlik.com/docs/DOC-7220

Regards

ASHFAQ

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Thanks, that's it