
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Conditional Formatting using value in 'This Cell'
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
- Tags:
- color
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can use your expression label like this,
if(expression label<.75, red(), green())
“Aspire to Inspire before we Expire!”

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Rob! I knew it had to be simpler than it appeared.
