topic Re: Change cell color in QlikView

Change cell color

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

hey all ,

how can change a cell color in a pivot table based on Conditions

Example: If (a>b, Red, a<b, Yellow).

hope you can help

Thanks

stabben23 — Fri, 18 Aug 2017 08:01:55 GMT

Have a look at tab "Visual Cues"

PrashantSangle — Fri, 18 Aug 2017 08:02:36 GMT

right click on cell ->custom format cell -> background color->calculated->right Expression like

if(a>b,Red(),Yellow())

Regards,

Anil_Babu_Samineni — Fri, 18 Aug 2017 08:27:47 GMT

May be this?

If(a>b, Red(), If(a<b, Yellow(), LightCyan())

neha_shirsath — Fri, 18 Aug 2017 11:52:15 GMT

Hi,

Use Expression-

if(a>b , red(),if(a<b, yellow(), black()))

Which background color you want to change -

1) only dimension?

Select Dimension expand + sign and your condition

2) only Expression?

Select Dimension expand + sign and your condition

OR using Visual ques option

3) You can right click on chart properties and go to custom format cell and based on your above condition add background.