Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
kfahri342
Contributor III
Contributor III

Conditional Format if one date greater than one month

Hi,

I have 2 columns.

1) DATE BASE

2) DATE CURRENT

What expression would I need to use to ensure, that if DATE CURRENT is 1 month greater than Date BASE the cell turns RED.

I am currently using a straight table.

Many Thanks

Kozan

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

May be

If([DATE CURRENT] > AddMonths([DATE BASE],1),Red())

View solution in original post

3 Replies
antoniotiman
Master III
Master III

May be

If([DATE CURRENT] > AddMonths([DATE BASE],1),Red())

Anil_Babu_Samineni

Perhaps this?

If([DATE CURRENT] > AddMonths([DATE BASE],1),RGB(255,1,500))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
kfahri342
Contributor III
Contributor III
Author

Thanks both, it works. Except that it is >= AddMonths