Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted
Creator
Creator

Lucie,

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

BR

Andreas

Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted

Hi,

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

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

Regards

ASHFAQ

Highlighted

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

Thanks, that's it