Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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
Henric_Cronström

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
Partner

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

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

Henric_Cronström

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

Not applicable
Author

Thanks Henric for the help.