topic Identifying the first displayed column in a Pivot Table in QlikView

Identifying the first displayed column in a Pivot Table

r3iuk — Thu, 01 May 2014 10:57:44 GMT

I have a pivot table with the Allow Pivoting option checked, so a user can move the columns about.

Is it possible from within a macro to identify which column has been set to be the first column in the table. I've tried using the Table Properties.DisplayOrder member but this seems to be unpopulated.

Thanks for any help you can provide.

Re: Identifying the first displayed column in a Pivot Table

bgerchikov — Thu, 01 May 2014 15:41:01 GMT

Hi Mike,

To resolve this problem there are two options:

1. Doesn't allow user to save the document

2. If you want to use macro, the table has to rebuild from scratch

Good luck!