Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
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)
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