topic Can someone please explain how can the end user perform sorting on the Pivot table columns on the QlikView Accesspoint. in QlikView

Can someone please explain how can the end user perform sorting on the Pivot table columns on the QlikView Accesspoint.

Wed, 23 Mar 2016 18:51:58 GMT

I know for straight table it is by double clicking on the column name with the Interactive sort option checked. but how to do it in pivot.

Re: Can someone please explain how can the end user perform sorting on the Pivot table columns on the QlikView Accesspoint.

cjohnson — Wed, 23 Mar 2016 20:30:34 GMT

Hi Jagveer,

That option is not available for pivot tables in Qlikview. A pivot table will always maintain the groups of its dimensions.

You can try to achieve this using macros; however you may want to consider using a straight table instead or have the sorting done on the actual chart (not interactive/dynamic). What is the reason you are using a pivot table -- is it to get a horizontal dimension (such as for putting it in date buckets), or is it to have different dimension groupings?

Thanks,

Camile

Re: Can someone please explain how can the end user perform sorting on the Pivot table columns on the QlikView Accesspoint.

settu_periasamy — Thu, 24 Mar 2016 05:21:18 GMT

Hi,

May be check this as Well..

Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)