Sorting data in pivot table with cyclic group

[#1]

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?

[qvwarning]

Lucie,

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

BR

Andreas

[jagan · Accepted solution]

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]

Hi,

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

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

Regards

ASHFAQ

[jonathandienst]

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

[#6]

Thanks, that's it