topic Expand in pivot table in QlikView

Expand in pivot table

Wed, 29 Aug 2012 15:24:03 GMT

In my report I am showing data in Pivot Table, most in collapsable format. Can i perform any action on button click to expand all the collapsed rows in one go.

Is there anyway to achieve this.

Thanks,

Re: Expand in pivot table

bgerchikov — Wed, 29 Aug 2012 17:36:14 GMT

Hi,

You can keep your pivot table Always Fully Expanded by checking this box in chart properties --> Presentation tab. Otherwise, users should expand/collapse manually.

Hope this helps.

Re: Expand in pivot table

Mon, 03 Sep 2012 06:36:32 GMT

Thanks Boris for your reply.

Yes, I can do that but in that case then collapse option doesn't appear on the screen.

Anyways there is another way to achieve this, user accessing the report via web can always right click on the column and say expand / collapse.