Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
prashanthd12
Contributor II
Contributor II

Remove + sign expansion pivot table Qliksense

 

Hi Experts,

 

I have a situtation where i need to build a pivot table where the expansion is upto level 3. 

 

In the example below OMAN location has two types RESIN FG and SHEET FG  and futher expanded to Material Grade values

But this expansion is only applicable for OMAN location value. Others should show the value at level 2

 

i see it automaticlly expanded for all values  even though there is no dimension value for level 3( Example CINCI in below screenshot ) 

i tried unchecking avoid NULL values for level 3 dimension but problem is whole CINCI dimension value disappears

How to avoid this?

 

 

 

prashanthd12_0-1694789425422.png

 

Labels (3)
0 Replies