Conditional Formatting a Columns in QlikSense

[Brunch]

Hopefully easy solution.  I have a table in Qlik Sense that I'm trying to format depending on the value in the cell.  ie, if the value is below 40, cell is red, if above, cell is green.

I loaded this expression but it just returns the green color.  any help is appreciated

=if(Column(G3_START_PLAN - Decision_Date) < 40,red (), green())

[Cascader]

try:

 if(Column(G3_START_PLAN) - Column(Decision_Date) < 40,red (), green())

not sure if Column function takes column name, I think it takes column number

[agigliotti · Accepted solution]

Hi @Brunch ,

As @Cascader said you should use column number if both of them are measures, else you can use the expression as below:

if( G3_START_PLAN - Decision_Date < 40, red(), green() )

I hope it can helps.

Best Regards

[Brunch]

Ahmed, thanks for the reply.  I tried that and didn't work either.  I also tried just putting in the Column and get the same result.  I'm just trying to get the formatting in Column 10 to change color if the value is less than 40, etc.

=if(Column(10) < 40,red (), green())

[Brunch]

Oh wow that worked.  Thanks