Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to do conditional formatting in Qlikview like the kind of thing below created in Microsoft Excel?
You can use the ColorMix Wizard
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
COLORMIX-function may help you
Peter
You can use the ColorMix Wizard
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
Yes, you can
If ( IsNull( <yourexpression> ) , White(), <colormix generated expression> )
Thanks very much