Can Qlikview do conditional formatting?

[Anonymous]

Is it possible to do conditional formatting in Qlikview like the kind of thing below created in Microsoft Excel?

[devarasu07]

Hi,

It can be done, can you share you mock data.

you just need apply conditional formating in the measure section like below if condition

if(sum(WeekTurn)>=8 and sum(WeekTurn)<=17.99,rgb(204, 255, 204),

if(sum(WeekTurn)>=18 and sum(WeekTurn)<=19.99,rgb(255, 173, 51),

if(sum(WeekTurn)<=9.999,rgb(255, 173, 51),

RGB(250, 128, 114))))

also check my sample app attached one.

Thanks,Deva

[sunny_talwar]

Check these out

Sorted Heatmap example

https://qlikcentral.com/2015/02/09/heatmaps-are-cool/

[prieper]

COLORMIX-function may help you

Peter

[Clever_Anjos · Accepted solution]

You can use the ColorMix Wizard

[Anonymous]

Thanks everyone.

I have used the ColorMix Wizard to create the following table in Qlikview but when there is no value the background colour is showing as red i.e. see Care Experience below.  Is there a way to show the background colour as white when there is no value?

Thanks

Greg

[Clever_Anjos]

Yes, you can

1. Copy your expression
2. Go to BackgroundColor expression
3. Use something like this

     If ( IsNull( <yourexpression> ) , White(), <colormix generated expression> )

[Anonymous]

Thanks very much