Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
CharanY28
Contributor
Contributor

Background Color in Pivot chart While expanding

Hi All,

I have Pivot chart as Below

1)

CharanY28_0-1742885277620.png

 



2)

CharanY28_0-1742829386999.png


I want to see the blue color for Total by Universities only when it's expanded , currently it's showing when even when It's not expanded also like in 1st picture, I want to Uncheck Full expanded and Collapse option and want to see Blue color for total only when expanded like in 2nd picture without expanding initially

How to do??

Please help thanks

Labels (1)
1 Solution

Accepted Solutions
JandreKillianRIC
Partner Ambassador
Partner Ambassador

Hi @CharanY28 

Just use Dimensionality() 

Something like 

=IF(Dimensionality() > 1, Blue(), White()) (just use this with your current color expression) 

Regards Jandre

 

 

Mark the solution as accepted that solved your problem and if you found it useful, press the like button! Check out my YouTube Channel | Follow me on LinkedIn

View solution in original post

1 Reply
JandreKillianRIC
Partner Ambassador
Partner Ambassador

Hi @CharanY28 

Just use Dimensionality() 

Something like 

=IF(Dimensionality() > 1, Blue(), White()) (just use this with your current color expression) 

Regards Jandre

 

 

Mark the solution as accepted that solved your problem and if you found it useful, press the like button! Check out my YouTube Channel | Follow me on LinkedIn