Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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