topic Re: Sorting data in pivot table with cyclic group in QlikView

Sorting data in pivot table with cyclic group

Mon, 20 Oct 2014 06:36:40 GMT

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?

Re: Sorting data in pivot table with cyclic group

qvwarning — Mon, 20 Oct 2014 06:57:43 GMT

Lucie,

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

Andreas

Re: Sorting data in pivot table with cyclic group

jagan — Mon, 20 Oct 2014 07:02:33 GMT

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

ashfaq_haseeb — Mon, 20 Oct 2014 07:06:57 GMT

Hi,

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

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

Regards

ASHFAQ

Re: Sorting data in pivot table with cyclic group

jonathandienst — Mon, 20 Oct 2014 07:07:07 GMT

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

Re: Sorting data in pivot table with cyclic group

Mon, 20 Oct 2014 07:16:28 GMT

Thanks, that's it