topic Re: Remove expansion from Pivot table in QlikView

Remove expansion from Pivot table

vipingarg23 — Mon, 14 Aug 2017 13:26:28 GMT

Hi Team,

I want to remove expansion sign from pivot table for some columns only(Dimensions). Can anyone help me?

Thanks.

Re: Remove expansion from Pivot table

Anil_Babu_Samineni — Mon, 14 Aug 2017 13:28:43 GMT

Can you explain little more?

Re: Remove expansion from Pivot table

vipingarg23 — Mon, 14 Aug 2017 13:33:26 GMT

Hi..

There are around 8 column in my pivot table. I want starting two column as Always expanded but not all. For all We can do directly by clicking on always fully expanded but I want this feature only for two columns.

Re: Remove expansion from Pivot table

Anil_Babu_Samineni — Mon, 14 Aug 2017 14:12:31 GMT

There is no specific option to get into. But, If you like to go using macro yes there is work around. Will you? Here i think you must hit another object either button / text box.

Re: Remove expansion from Pivot table

vipingarg23 — Mon, 14 Aug 2017 14:21:40 GMT

Yes..Sure...

Re: Remove expansion from Pivot table

Anil_Babu_Samineni — Mon, 14 Aug 2017 14:35:42 GMT

Normally, I don't prefer to use Macros and I would ask you to recommend / teach expand and collapse to USERs and then they came to know where we are doing and done this?

tamilarasu‌ please have a look on this thread using Macros?

Re: Remove expansion from Pivot table

tamilarasu — Mon, 14 Aug 2017 17:34:11 GMT

Hi Vipin,

Instead of Macros, you can use bookmarks by enabling the option "Include Layout State". Create a bookmark for the levels of expansion you need (without any selections) and save it. After that apply the bookmark while activating the sheet through sheet activate trigger.

Re: Remove expansion from Pivot table

vipingarg23 — Mon, 14 Aug 2017 18:35:01 GMT

Great...It worked....Thanks for your help.

Re: Remove expansion from Pivot table

vishsaggi — Mon, 14 Aug 2017 18:37:39 GMT

Hello Vipin,
Can you close the thread accordingly if you got the answer.

Thanks,