Color formula with %'s

[Anonymous]

Hello Qlik friends,

I am trying to write a color expression formula within a pivot table, saying (in plain terms) if column 2 is greater or less than 10% of column 1, then color it red. Otherwise, color it gray.

I am familiar with Qlik formulas and color formulas, just need a little bit of guidance!

Thanks!

Ken

[priyalvp24 · Accepted solution]

hi,

try this

If(column(2)>((column(1)*10)/100) or column(2)<((column(1)*10)/100) ,red(),green())

Thanks,

Priyal.