Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
amigo007
New Contributor III

Re: Filter nulls/non nulls on List Box

Thanks.

This looks as a simple and a nice solution, the only thing I have null values and not '-'.  I guess QlikView displays nulls as '-' in tables. So '-' character can not be used in the condition.

Highlighted
antoniotiman
Honored Contributor III

Re: Filter nulls/non nulls on List Box

Hi

See Attachment

Highlighted
MVP
MVP

Re: Filter nulls/non nulls on List Box

With table box, it might not be possible that way. PFA for 'All' option solution.

Highlighted
amigo007
New Contributor III

Re: Filter nulls/non nulls on List Box

Thanks.

This looks great but the issue is the same as I mentioned to Thirumala below, I'm having nulls in my data and not '-' which is just displayed By QlikView when values are null.

Highlighted
antoniotiman
Honored Contributor III

Re: Filter nulls/non nulls on List Box

Yes.

Change expression in List Box to

=If([Account Number]='-' or Len([Account Number])=0,'Yes','No') 

Highlighted
vishsaggi
Esteemed Contributor III

Re: Filter nulls/non nulls on List Box

Try like:

= IF(Len(Trim([Account Number])) = 0 , 'Yes', 'No')

trdandamudi
Honored Contributor II

Re: Filter nulls/non nulls on List Box

Got it. Then use the below expression:

=If(Len(Trim([Account Number]))>0,'No','Yes')

Highlighted
amigo007
New Contributor III

Re: Filter nulls/non nulls on List Box

Thanks all for your help. All the suggestions make sense but still didn't get my problem solved 100%. After a few researches, it turned out that it's tricky how QlikView handles the null values. I read a great document from this thread and concluded that converting null values to a string, e.g. <NULL>, in the load script and then applying your suggested script did the trick.

=If(([Account Number])<>'<NULL>','No','Yes')

PS: data source from SQL Server

View solution in original post

Highlighted
vishsaggi
Esteemed Contributor III

Re: Filter nulls/non nulls on List Box

Glad you found out. Close the Thread marking yours as Correct and mark if any helpful.