topic null value in QlikView

null value

amiroh81 — Sun, 06 Jul 2014 08:55:56 GMT

Hello all,

I have a table column that possess multiple values, some of which appears with the symbol -, it seems to me that it is NULL.

I want to add list box to choose the values and when it appears in the sign - appears to me NULL for example a particular text.

How do I do this without making a change script if possible?

I read a bit on the subject and I left confused and would love if you could help me.

Thanks in advance

Re: null value

diegofcaivano — Mon, 07 Jul 2014 16:19:54 GMT

Hi Amir,

You won't be able to select null values from any chart or field because of how QlikView works.

The only way I have analyzed and filtered null values is by replacing them previously in the script.

Diego.-

Re: null value

jaimeaguilar — Mon, 07 Jul 2014 16:26:36 GMT

Hi,

you can use the function NULLASVALUE. You have to go to script and type this:

NULLASVALUE YourField;

Set NullValue = 'N/A';

the second line is a system variable called NullValue which lets you assign a default value to nulls. So you can set whatever text you want (instead of 'N/A'). This way when you reload script and create a listbox, you'll see that null values have been assigned with a selectable value,

regards