topic Re: Remove a value from a list box? in QlikView

Remove a value from a list box?

Anonymous — Tue, 03 Mar 2015 19:44:11 GMT

Trying to remove a value from a list box...Below is what I have but I can still select the blank value in the list box. Need to remove the value completly from the list box

List box:

1/1/2014

2/1/2014

12/31/999 (Need to remove)

=IF(termDt='12/31/9999 12:00:00 AM','',termDt)

Re: Remove a value from a list box?

Anonymous — Tue, 03 Mar 2015 19:50:45 GMT

You can try this:

=IF(termDt='12/31/9999 12:00:00 AM',null(),termDt)

=IF(termDt<>'12/31/9999 12:00:00 AM',termDt)

Hope it helps.

Re: Remove a value from a list box?

Anonymous — Tue, 03 Mar 2015 19:55:27 GMT

=IF(Not WildMatch(termDt, '12/31/999*'),termDt)

Re: Remove a value from a list box?

maxgro — Tue, 03 Mar 2015 20:01:03 GMT

=IF(termDt<>'12/31/9999 12:00:00 AM',termDt)