topic Re: Unable to select 'blank' in filter in QlikView

Unable to select 'blank' in filter

Wed, 25 Nov 2020 16:16:04 GMT

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)

Re: Unable to select 'blank' in filter

marcus_sommer — Wed, 04 Oct 2017 15:56:18 GMT

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

Re: Unable to select 'blank' in filter

lorenzoconforti — Wed, 04 Oct 2017 15:57:07 GMT

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)

Re: Unable to select 'blank' in filter

andrei_delta — Thu, 05 Oct 2017 14:14:02 GMT

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