topic Re: Pivot Table - Control expand level in QlikView

Pivot Table - Control expand level

Fri, 04 Dec 2015 08:17:23 GMT

Hi All,

I am using the pivot table which having six levels of selection as follows. Currently selection points in each level.

I need to implement following rules here

Corporate / Merchant / Campaign Name columns are always displayed.
User can click on icon ‘+’ in Campaign Name column, then Start Date / End Date / Type / Status columns are all displayed in one time (with only one click).
Icons ‘+’ and ‘-’ are removed from Corporate / Merchant / Start Date / End Date / Type / Status columns.

I could not find any way to solve this. Can you please help me out?

Thanks,

K.Mugunthan

Re: Pivot Table - Control expand level

Gysbert_Wassenaar — Mon, 07 Dec 2015 18:26:56 GMT

What you want is not possible. You can either expand/collapse the entire dimension or manually expand each dimension. There's no way to automate this or add conditions to define what can and cannot be expanded.

Re: Pivot Table - Control expand level

Tue, 08 Dec 2015 03:40:33 GMT

Thanks gwassenaar‌ for you reply. I am quite new to the qlikview and macro. Can I implement this through macro ?

Regards,

K.Mugunthan

Re: Pivot Table - Control expand level

Gysbert_Wassenaar — Tue, 08 Dec 2015 16:57:20 GMT

Not as far as I know.