Pivot Table - Behave more like a hierarchy

[#1]

Hello fellow QlikViewers,

when using a pivot table and I expand one dimension value, all the other same dimension values also expand. Is it possible to somehow suppress this behavior. My users only want the pivot table to expand where they click the + symbol.

I added a test pivot for you. For instance if I expand/collapse Category 1 in Austria the entry for Category 1 in Germany also expand/collapse.

BR,

Harald

[Anonymous]

hi,

try like this.  clik right mouse on country and then use the funcion of reduction all

then u store and try to open with +

Andrea

[#3]

Thanks for the answer, but it doesn't work.

Harald