Discussion board where members can get started with QlikView.
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
12/31/999 (Need to remove)
=IF(termDt='12/31/9999 12:00:00 AM','',termDt)
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.
View solution in original post
=IF(Not WildMatch(termDt, '12/31/999*'),termDt)