Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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: