Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
joshabbott
Creator III
Creator III

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

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:

joshabbott_0-1670421257399.png

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?

Labels (1)
2 Replies
vinieme12
Champion III
Champion III

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 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
joshabbott
Creator III
Creator III
Author

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:

joshabbott_0-1670606162431.png