topic Re: How to give background color to cell along with Values?(Not through Visual cues) in QlikView

How to give background color to cell along with Values?(Not through Visual cues)

Shubham_Deshmukh — Thu, 28 Sep 2017 07:30:08 GMT

For ABC row,% C condition ( if +ve,red())

For XYZ row,% C condition (If - ve , red())

Means,I have different conditions for each row.

And I want to color the cell along with % C value,but I am getting one out of them only.

Pls help.

Re: How to give background color to cell along with Values?(Not through Visual cues)

PrashantSangle — Thu, 28 Sep 2017 07:37:03 GMT

right click on cell> format cell > apply color.

Regards

Re: How to give background color to cell along with Values?(Not through Visual cues)

prat1507 — Thu, 28 Sep 2017 07:56:28 GMT

You can use something like this

pick(match(Dim,'ABC','XYZ'),

if(% C condition>0,rgb(),rgb()),

if(% C condition>0,rgb(),rgb()))

You can specify rgb codes as per your wish.

Regards

Pratyush

Re: How to give background color to cell along with Values?(Not through Visual cues)

Shubham_Deshmukh — Fri, 29 Sep 2017 05:17:09 GMT

Hi Pratyush,

I already tried it , it's not working

Re: How to give background color to cell along with Values?(Not through Visual cues)

Shubham_Deshmukh — Fri, 29 Sep 2017 05:53:03 GMT

I Got the answer.

Write the normal condition in expression & write compare and color codes condition in background color tab.So, it will give you background color and value as well.

Re: How to give background color to cell along with Values?(Not through Visual cues)

prat1507 — Fri, 29 Sep 2017 07:36:12 GMT

Yes, the expression I gave you has to be written in the background color of the expression.

Nice, you got that done.

Regards
Pratyush

Re: How to give background color to cell along with Values?(Not through Visual cues)

Shubham_Deshmukh — Mon, 02 Oct 2017 09:32:34 GMT

Ohhhh,previousely, I didnt get it 🙂

Thanks.