How to add custom color on each expression?

[jim_chan]

Hi guys,

i have created a pivot table. problem is :

i want to add custom background color on the expression, but i don;t know how.

- i have tried background color on in the expression tab - ends up it colored my data instead of the expression title(Cost A - Cost D).

- I have tried custom format cell as well, but i only want Cost A-D in blue and Cost E-G is Green. - ends up all in blue.

So. Pls help! how to custom it?

Rgds

Jim

[vishsaggi]

Can you post a sample app or the expression you are using for background color?

[#3]

hi,

Can u send ur Qvw

[varshavig12]

This should work in the background color of your expression:

if(Expression_name='Cost A' or Expression_name='Cost B' , Blue() ,

if(Expression_name='Cost E', red()

))

if not, post a sample.

[jim_chan]

ok let me try it out.

[jim_chan]

nope. not working. maybe do you have a sample of your solution?

[Greg_Williams]

There is a color wizard in background color of chart expression. My suggestion, play with it a bit and get use to it. Best practice would be to use variables to control color expressions. Logic can be used to control dimension or value threshold displays. Have a look at https://community.qlikview.com/thread/73570

-gw

[#8 · Accepted solution]

Use visual cues property

u can get it

[sunny_talwar]

You would basically need an expression used under the Background color on the dimension tab. I used the following expression:

=If(WildMatch(Cost, '*A', '*B', '*C', '*D'), LightBlue(),

If(WildMatch(Cost, '*E', '*F', '*G'), LightGreen()))

[jim_chan]

Hello Sunny ! let me try it out, and will let you know about it