topic Pivot Table - Expand 1 Dimension expands all dimensions (if the same name even under a diff dimension) in App Development

Pivot Table - Expand 1 Dimension expands all dimensions (if the same name even under a diff dimension)

joshabbott — Wed, 07 Dec 2022 13:56:47 GMT

Hello,

I've noticed functionality in QlikSense pivot tables where when I expand a nested dimension with the same values inside of another dimension, it expands all of the dimensions (not just the selected expansion).

Here is a simple example I came up with:

InlineTable:
Load * Inline [
Lev1,Lev2,Lev3,Amt
A,dog1,cat1,1
A,dog1,cat2,1
A,dog2,cat1,1
A,dog2,cat2,1
B,dog1,cat1,1
B,dog1,cat2,1
B,dog2,cat1,1
B,dog2,cat2,1
];

With a pivot table that looks like this:

I expanded under Level1, the value 'A', then under Level2, the value 'dog1'. When I expand 'dog1' under 'A', it also expands 'dog1' under 'B'. Is there a way to make this so only 'dog1' under 'A' expands?

Re: Pivot Table - Expand 1 Dimension expands all dimensions (if the same name even under a diff dimension)

vinieme12 — Wed, 07 Dec 2022 15:57:22 GMT

this is how pivot table in Qliksense is designed to behave, all items at a level will expand and collapse together

we cannot expand/ collapse individual items at a level

Re: Pivot Table - Expand 1 Dimension expands all dimensions (if the same name even under a diff dimension)

joshabbott — Fri, 09 Dec 2022 17:16:08 GMT

I'm not sure I understand you correctly:

"all items at a level will expand and collapse together. We cannot expand/collapse individual items at a level"

In the below case, I'm expanding and collapsing items at a level. If they are named exactly the same, that is when they are expanding under both dimensions: