NULL(-) in Selectbox

[mokitsu61]

Hi,

I'm using QV Desktop 12.

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

Thank you.

[ogautier62 · Accepted solution]

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]

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