Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
You can use your expression label like this,
if(expression label<.75, red(), green())
Thanks Rob! I knew it had to be simpler than it appeared.