Change cell color

mario-sarkis · ‎2017-08-18

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 · ‎2017-08-18

Have a look at tab "Visual Cues"

PrashantSangle · ‎2017-08-18

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

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anil_Babu_Samineni · ‎2017-08-18

May be this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

neha_shirsath · ‎2017-08-18

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.

Related Topics