Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cell color in pivot based on Dimensions

Hi,

I have created a pivot table with two dimensions dimension1 and dimension2

One aligned horizontally and second vertically.

Say the dimension1 contains value a,b,c and dimension2 contains value x,y,z as

Dimension1\Dimension2xyz
aaxayaz
bbxbybz
ccxcycz

I want the background cell color to be fixed to some specific color and different for all the cells. So, Have written an expression in background color of expression.

The dimensions are static.

So based on selections, few cell value turns to zero and also the background color fades to white.

Is there any way to handle this?

hic can u suggest something?

Thanks,

Anjali Gupta

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

I assume that you have some color expression where you use field references for dimension1 and dimension2 to determine the color. Then you may need to use Only({1} dimension1) and Only({1} dimension2) instead.


HIC

View solution in original post

4 Replies
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

Do this.

1. Go to Menu bar --> View --> click on Design Grid

2. right click on pivot table and click on custom format cell

3. On custom format cell window you will find Apply change to drop down. Select Current expression from this drop down.

4. And Change the background color.

5. Along with the above you have to do the background color expression.

Here trick is Background color expression will take precedence and for all cross tab nulls/zeros design grid color will take next.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

For dimensions(s) that is are not selected (or not possible), you want the cells background to be white? You can use any aggregation function to test the "1 - $" set, which is the inverse of current selections.

if(count({1-$} dimension1)>0, white())

-Rob

hic
Former Employee
Former Employee

I assume that you have some color expression where you use field references for dimension1 and dimension2 to determine the color. Then you may need to use Only({1} dimension1) and Only({1} dimension2) instead.


HIC

Not applicable
Author

Thanks Henric for the help.