topic Re: Force Always one Selected in List Box in QlikView

Force Always one Selected in List Box

Tue, 23 Apr 2013 11:25:51 GMT

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

Re: Force Always one Selected in List Box

Tue, 23 Apr 2013 11:37:16 GMT

Hi,

Try this

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

Regards,

Amay

Re: Force Always one Selected in List Box

jagan — Tue, 23 Apr 2013 11:41:26 GMT

Hi,

Try like this

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

Regards,

Jagan.