Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Remove a value from a list box?

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)

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

You can try this:

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


or


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


Hope it helps.

View solution in original post

3 Replies
Highlighted
Creator III
Creator III

You can try this:

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


or


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


Hope it helps.

View solution in original post

Highlighted
Creator III
Creator III

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

Highlighted
MVP
MVP

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