topic Re: Conditional formatting in Straight table in QlikView

Conditional formatting in Straight table

Wed, 11 Mar 2015 12:39:04 GMT

Hi All,

I need the expression to change the cell background color according.

if its 0 - 40% is Red

41% - 70% is Yellow

71% - 100% is Green

Like below.

Thankyou all.

Anonymous — Wed, 11 Mar 2015 12:41:16 GMT

expand + sign of expression put if condition code in color option

maxgro — Wed, 11 Mar 2015 12:43:14 GMT

try with background color

if(yourexpression >0 and yourexpression <=0.4, rgb(255,0,0),

if(yourexpression >0.4 and yourexpression <=0.7, rgb(255,255,0),

if(yourexpression >0.7 and yourexpression <=1, rgb(0,255,0),

rgb(?,?,?)

)))

sunny_talwar — Wed, 11 Mar 2015 12:46:38 GMT

Is this what you are trying to do? PFA

Best,

Wed, 11 Mar 2015 13:27:24 GMT

Yes Sunindia am trying for that

sunny_talwar — Wed, 11 Mar 2015 13:29:20 GMT

Have you looked at the attached qvw file? It will help you understand what needs to be done to create the same view.

Best,

Wed, 11 Mar 2015 13:36:02 GMT

Thank you i got it