Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Force Always one Selected in List Box

Hi,

I am using this expression

IF(ACCT.CLOSE_DTE = '<=' & TODAY(),'Closed','Open')

However, it is not working..'Open' always populates the field.  Basically I want 'Closed' to display when the close date is less than or equal to today's date, otherwise display 'Open'.

I appreciate any help guys?

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

Try this

IF(ACCT.CLOSE_DTE <= TODAY(),'Closed','Open')

Regards,

Amay

View solution in original post

2 Replies
Not applicable
Author

Hi,

Try this

IF(ACCT.CLOSE_DTE <= TODAY(),'Closed','Open')

Regards,

Amay

View solution in original post

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

IF(Max(ACCT.CLOSE_DTE) <= TODAY(),'Closed','Open')

Regards,

Jagan.