NULLASVALUE causing lag in reload time

[#1]

Hi,

I would just like to know if someone could clarify, why a NULLASVALUE would cause a lag in reload time?

Thank you

[#2]

using is as follows;

NULLASVALUE *;

SET NullValue = ' ';

[varunreddy]

Hi Adam,

You might be having many null values in your data.

Use this

SET NullValue = 'Unknown';

NULLASVALUE *;

Take a list box and try to check the null values.

Hope this works!

Regards,

Varun

[Peter_Cammaert]

Is NULLASVALUE not working (Title) or just slower than expected?

[qlikviewwizard]

Hi Please check this links:,

NULL handling in QlikView

Null Value Handling using 3 Value Logic

NULLINTERPRET

[jonathandienst]

NULLASVALUE * will convert all null values into an empty string. This will change the behaviour of where clauses without special null handling and it will change the behaviour of joins (you cannot join on a null, but you can on an empty string). Some of these behaviour changes could lead to changes in the amount of data and the load times.

[#7]

slower than expected. It is causing the reload to lag at a certain point. If I take the NULLASVALUE out of my script then the model reloads as normal.

[kkkumar82]

Hi ,

Do you really wanted every null value in each of columns to something or specific columns, if it is specific columns then

use

Nullasvalue column1, column2;

Set Nullvalue = something

otherwise

The above logic is having a problem every null value in the columns will be changing to the value "something" , if you column specific replacement use in the load script of the column as

if(isnull(column), something,column)

I think because of * it is taking more time.

Hope you have understand.

[#9]

I understand yes. I would however want all the null values in the model to be blank space so that is is select-able for the user.

Could the NULLASVALUE be affected by a scripted indicator?

Thank you for your assistance.

[kkkumar82 · Accepted solution]

Hi,

Ok then use the first solution and Set NULLVALUE = 'NULL' .

Thanks

Kiran Kumar