Conditional Formatting using value in 'This Cell'

[cfountain72]

Hi,

This seems like a pretty simple request, but I'm having trouble finding the answer. I have a table in Qlik Sense and want to color the cells based on certain conditions. I can use something like:

if(verrrrrrrrrrrrrry loooooooong expresssssssion < .75, red(), green())

But is there a way to say:

if(This Cell's Value <.75, red(), green())

Basically, refer to the value in the actual cell without having to reenter the expression(s) used to calculate the cell's value. (Similar to what you can do in Excel's conditional formatting.)

Thanks in advance,

Chris

[rwunderlich · Accepted solution]

The function is "Column(n)".  n=1 refers to the first measure column, n=2 the second and so on.  So assuming it's the first measure in the chart:

if(Column(1) <.75, red(), green())

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[HirisH_V7]

You can use your expression label like this,

if(expression label<.75, red(), green())

[cfountain72]

Thanks Rob! I knew it had to be simpler than it appeared.