Multi box not dispalying Null values - Qlik Community

Report Inappropriate Content · ‎2012-12-11

Hi,

I have a multi box, which displays a list of dates. The proiblem is that I dont have the option of filtering the data for rows that have a Null date.

Why is this and is there a away around this? I've checked the properties and the ignore null, is not ticked.

Thank you in advance

Simon

sujeetsingh · ‎2012-12-11

just ignore it either at scripting level or just go with set analysis....

OR Plz give up a sample...

Report Inappropriate Content · ‎2012-12-11

use set analysis....dat shud solve ur problem....

Or · ‎2012-12-11

Hello Simon,

It is not possible to select null values directly - there is no value to select. I would recommend adding a new field in your script:

If(isnull(Date),'Select Null Dates') as NullDates

You can then use this in a listbox or multibox to select all rows where the date is null, without having to actually use the date column directly.

There may be other (cleaner) ways to get this done, but this is the one I use.