topic Can Qlikview do conditional formatting? in QlikView

Can Qlikview do conditional formatting?

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

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

Re: Can Qlikview do conditional formatting?

devarasu07 — Fri, 25 Aug 2017 10:14:03 GMT

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

Re: Can Qlikview do conditional formatting?

sunny_talwar — Fri, 25 Aug 2017 10:15:16 GMT

Check these out

Sorted Heatmap example

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

Re: Can Qlikview do conditional formatting?

prieper — Fri, 25 Aug 2017 10:43:28 GMT

COLORMIX-function may help you

Peter

Re: Can Qlikview do conditional formatting?

Clever_Anjos — Fri, 25 Aug 2017 10:51:47 GMT

You can use the ColorMix Wizard

Re: Can Qlikview do conditional formatting?

Anonymous — Wed, 30 Aug 2017 10:51:05 GMT

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

Re: Can Qlikview do conditional formatting?

Clever_Anjos — Wed, 30 Aug 2017 11:12:01 GMT

Yes, you can

Copy your expression
Go to BackgroundColor expression
Use something like this

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

Re: Can Qlikview do conditional formatting?

Anonymous — Wed, 30 Aug 2017 11:47:52 GMT

Thanks very much