Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
kfahri342
Contributor III
Contributor III
‎2017-11-17 05:20 AM

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,301 Views
0 Likes
1 Solution

Accepted Solutions
antoniotiman
Master III
Master III
‎2017-11-17 05:45 AM

May be

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

View solution in original post

992 Views
0 Likes
3 Replies
antoniotiman
Master III
Master III
‎2017-11-17 05:45 AM

May be

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

993 Views
0 Likes
Anil_Babu_Samineni
MVP
MVP
‎2017-11-17 05:47 AM

Perhaps this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
992 Views
0 Likes
kfahri342
Contributor III
Contributor III
‎2017-11-17 06:01 AM
Author

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

992 Views