topic Re: background expression in QlikView

background expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

how to use background expression in pivot table, for example, I want to use light gray a particular columns.

Re: background expression

prma7799 — Thu, 10 May 2018 05:07:31 GMT

Go to Expression >> + sign >> Background color >> write your condition

Re: background expression

agastya — Thu, 10 May 2018 05:18:19 GMT

Are you talking about Background Color for particular column?

Re: background expression

hiteshpatil11 — Thu, 10 May 2018 05:23:18 GMT

Hi,

You can use Background Color expression in Chart Properties for column color in below manner:

Example: I have Subject and User Columns in my table. I want to make columns light grey where User is User 1. For rest of the users column should be green.

1. Expand the Dimension Chart for it's properties, you'll get below options:

2. Double click Background color property, you'll get Expression Window.

3. For my example, expression will be in this manner:

=if(User='User 1',RGB(211,211,211),Green())

here, RGB(211,211,211) is color code for Light Grey.

4. Output:

Similarly you can apply Background Color in Expressions.

Regards,

Hitesh

Re: background expression

Anonymous — Thu, 10 May 2018 07:13:20 GMT

thank you so much, I've got the answer.

Re: background expression

shiveshsingh — Thu, 10 May 2018 07:21:55 GMT

Please close the thread.

Re: background expression

Anonymous — Thu, 10 May 2018 18:46:59 GMT

hi Hitesh Patil

thanks, I've done something you told me, but there is one problem for zero value, it does not work, please look at my qv picture. Actually, I would like to green 102_Q columns here.

Re: background expression

hiteshpatil11 — Fri, 11 May 2018 05:45:35 GMT

Hi Ali,

I think it's NULL and not Zero Values that are troubling here. It is difficult to put Null Columns in color, please see if below link can help you in some way.

how to change background color for null values in a table

Thanks,

Hitesh

Re: background expression

Anonymous — Fri, 11 May 2018 12:48:48 GMT

Hi Hitesh Patil

thank you so much for you're recommendation.