Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
datapitipa
Contributor
Contributor

Background Color Expression in TABLE

Hi all,

I have a column in TABLE with this formula ==>  =Interval(Now()-Last_Update_Date,'h')

and I would like show the column green (#93c47d) when this value is >= 48. I tried this, but the background is always white

=if(Interval(Now()- Last_Update_Date,'h') >= 48, '#93c47d', white())

Thanks in advance 

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Interval is a formatting function, i.e. - it doesn't change the underlaying number. Try like:

if(Floor((Now()- Last_Update_Date)*24) >= 48, '#93c47d', white())

Note: you might not need floor() based on your requirement.

View solution in original post

2 Replies
Peca
Contributor II
Contributor II

Hi,

You can try this:

=if(Interval(Now()- Last_Update_Date,'h') >= 48, RGB(147,196,125), white())

tresesco
MVP
MVP

Interval is a formatting function, i.e. - it doesn't change the underlaying number. Try like:

if(Floor((Now()- Last_Update_Date)*24) >= 48, '#93c47d', white())

Note: you might not need floor() based on your requirement.