topic How to sort column (from dimension) in pivot table? in QlikView

How to sort column (from dimension) in pivot table?

Tue, 16 Dec 2014 12:18:32 GMT

Hi All - Is it possible to sort column (where data comes in as dimension) in the pivot table? Updating 'Sort' tab in pivot table properties didn't work.

Thanks in advance for your insights.

Re: How to sort column (from dimension) in pivot table?

MK_QSL — Tue, 16 Dec 2014 12:23:23 GMT

Interactive sort is not possible in Pivot Table..

you have to sort it first according to the first dimension, then according to the next,

Re: How to sort column (from dimension) in pivot table?

Tue, 16 Dec 2014 12:38:35 GMT

MRKachhiaIMP Thanks Manish! However, my first dimension is not displayed in the table as it is a randomly generated arbitrary ids generated by the system. Using Name as a second dimension. How can we sort by Name?

Re: How to sort column (from dimension) in pivot table?

MK_QSL — Tue, 16 Dec 2014 12:41:03 GMT

Provide sample data or sample apps...please

Re: How to sort column (from dimension) in pivot table?

Tue, 16 Dec 2014 13:13:04 GMT

What you can do is: do a fast type change to Straight table. If you want your data to be sorted, just switch, in straight table interactive sorting works. I don't think you can sort interactively, nonetheless you can use the sort tab to sort your dimensions for the desired result.

Best,