Pivot Table - Control expand level

[#1]

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

[Gysbert_Wassenaar]

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.

[#3]

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

Regards,

K.Mugunthan

[Gysbert_Wassenaar]

Not as far as I know.