topic Re: NULLASVALUE NOT WORKING in QlikView

NULLASVALUE causing lag in reload time

Thu, 20 Aug 2015 13:48:28 GMT

Hi,

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

Thank you

Re: NULLASVALUE NOT WORKING

Thu, 20 Aug 2015 13:50:00 GMT

using is as follows;

NULLASVALUE *;

SET NullValue = ' ';

Re: NULLASVALUE NOT WORKING

varunreddy — Thu, 20 Aug 2015 14:17:51 GMT

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

Re: NULLASVALUE NOT WORKING

Peter_Cammaert — Thu, 20 Aug 2015 14:21:20 GMT

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

Re: NULLASVALUE NOT WORKING

qlikviewwizard — Thu, 20 Aug 2015 14:26:44 GMT

Hi Please check this links:,

NULL handling in QlikView

Null Value Handling using 3 Value Logic

NULLINTERPRET

Re: NULLASVALUE NOT WORKING

jonathandienst — Thu, 20 Aug 2015 14:28:59 GMT

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.

Re: NULLASVALUE NOT WORKING

Fri, 21 Aug 2015 06:33:08 GMT

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.

Re: NULLASVALUE causing lag in reload time

kkkumar82 — Fri, 21 Aug 2015 07:48:11 GMT

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.

Re: NULLASVALUE causing lag in reload time

Fri, 21 Aug 2015 08:02:52 GMT

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.

Re: NULLASVALUE causing lag in reload time

kkkumar82 — Fri, 21 Aug 2015 10:53:58 GMT

Hi,

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

Thanks

Kiran Kumar

Re: NULLASVALUE causing lag in reload time

Fri, 21 Aug 2015 11:17:04 GMT

Thank you for you help