- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Conditional Formatting a Columns in QlikSense
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())
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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())
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oh wow that worked. Thanks