Unable to select 'blank' in filter

[#1]

I have a field named Project Number , which is populated for some cases and for rest it is blank. When i select this field in filter pane,i do not get option to select 'blank'. How to get the 'blank' data from filter (eg where Project Number is not available)

[marcus_sommer]

You need to fill these records with real values maybe with '#NV' or 'NULL' or similar. Here you will find many useful informations about the NULL handling in QlikView.

- Marcus

[lorenzoconforti]

That happens because probably your vales are Null

You need to fix it in your loading script by either using NullAsValue (NullAsValue ‒ QlikView) or IsNull (when loading the specific field you have issues with)

[andrei_delta]

Hello,

Or you can use alt([Project Number],0) as [Project Number] in your script to so that the blanks to take the value 0

Hope it helps,

Andrei