topic Re: How to add custom color on each expression? in QlikView

How to add custom color on each expression?

jim_chan — Thu, 04 Aug 2016 03:14:05 GMT

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

Re: How to add custom color on each expression?

vishsaggi — Thu, 04 Aug 2016 03:21:24 GMT

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

Re: How to add custom color on each expression?

Thu, 04 Aug 2016 03:41:26 GMT

hi,

Can u send ur Qvw

Re: How to add custom color on each expression?

varshavig12 — Thu, 04 Aug 2016 03:53:14 GMT

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.

Re: How to add custom color on each expression?

jim_chan — Thu, 04 Aug 2016 03:56:09 GMT

ok let me try it out.

Re: How to add custom color on each expression?

jim_chan — Thu, 04 Aug 2016 04:00:29 GMT

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

Re: How to add custom color on each expression?

Greg_Williams — Thu, 04 Aug 2016 04:07:54 GMT

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

Re: How to add custom color on each expression?

Thu, 04 Aug 2016 04:13:50 GMT

Use visual cues property

u can get it

Re: How to add custom color on each expression?

sunny_talwar — Thu, 04 Aug 2016 04:46:28 GMT

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()))

Re: How to add custom color on each expression?

jim_chan — Thu, 04 Aug 2016 05:48:48 GMT

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

Re: How to add custom color on each expression?

jim_chan — Thu, 04 Aug 2016 05:54:31 GMT

Hello Sunny,

But My "Cost" is expression. So, can i still create a custom background color for each of the expression?

Re: How to add custom color on each expression?

sunny_talwar — Thu, 04 Aug 2016 06:01:08 GMT

That makes your life a lot more easier. When you will click on the + sign next to your expression label, you will see Background color show up. For the expression A,B,C, &D add =Blue() and for E,F,G add =Green()

Re: How to add custom color on each expression?

sdmech81 — Thu, 04 Aug 2016 06:06:32 GMT

Hi,

store the rgb colors in variables like,light blue n green as per your wish.then use the these variables in your expression.

Next as mentioned by others in above post, if you want background coloring of dimension then you should write the condition in dimension tab n then background coloring.If for expression then in expression background coloring.

your expression,cab be like sunny or varsha, but would suggest try using pick and try to avoid if in expressions aswell.

attach file if still facing problem.

--sachin

Re: How to add custom color on each expression?

jim_chan — Thu, 04 Aug 2016 06:12:01 GMT

nope. by applying the background, it did change the bg color to blue. but i wanted the Cost A(title/header) to have Blue background instead.

How can i do that Sunny?

Rgds,

Jim

Re: How to add custom color on each expression?

jim_chan — Thu, 04 Aug 2016 06:49:04 GMT

ok ..... is this one! Thanks!!!!!