topic Re: NULL(-) in Selectbox in QlikView

NULL(-) in Selectbox

mokitsu61 — Wed, 29 Aug 2018 08:18:03 GMT

Hi,

I'm using QV Desktop 12.

How can I select NULL value ( - ) in Selectbox?

Thank you.

ogautier62 — Wed, 29 Aug 2018 08:29:46 GMT

Hi,

you have to use another field :

example : fields Item and supplier

you want to look at item with null supplier :

Select all in supplier

Select excluded values in item

regards

Anonymous — Wed, 29 Aug 2018 09:12:18 GMT

To select explicit null values I define in script something like

if isnull(field), 'N/A', field) as field

there are some Options to do this.

Then you may select N/A in selection boxes