Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pivot Table - Control expand level

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?

Untitled.png

Thanks,

K.Mugunthan

3 Replies

Re: Pivot Table - Control expand level

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.


talk is cheap, supply exceeds demand
Not applicable

Re: Pivot Table - Control expand level

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

Not as far as I know.


talk is cheap, supply exceeds demand
Community Browser