Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
MVP
MVP

Re: Sorting data in pivot table with cyclic group

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.

5 Replies
qvwarning
Contributor

Re: Sorting data in pivot table with cyclic group

Lucie,

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

BR

Andreas

MVP
MVP

Re: Sorting data in pivot table with cyclic group

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.

Re: Sorting data in pivot table with cyclic group

Hi,

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

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

Regards

ASHFAQ

MVP
MVP

Re: Sorting data in pivot table with cyclic group

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

Re: Sorting data in pivot table with cyclic group

Thanks, that's it

Community Browser