topic Scripting, adding a calculated field to a table in QlikView

Scripting, adding a calculated field to a table

Mon, 09 Sep 2013 09:03:43 GMT

I have this table:

in my scipt i want to add a new field: Formål
if Formål_tmp has a value then use this value, else use the value in Bærer

I have tried this:

But it doesnt work. The result is.

Can anyone help?

Jesper

Re: Scripting, adding a calculated field to a table

tresB — Mon, 09 Sep 2013 09:11:00 GMT

Try this:

If(Len(Trim(Formal_tmp))=0, Barrer, Formal_tmp) as Formal

Re: Scripting, adding a calculated field to a table

Brice-SACCUCCI — Mon, 09 Sep 2013 09:11:43 GMT

Hi,

try adding the column dato to your resident load.

When you don't, you only get existing couples of (Baerer, Formal_tmp). The '-' (null) value here is an absence of value, not a real null-value in the Formal_tmp column.

Regards,

Brice

EDIT: Here is a great article concerning NULL values

NULL handling in QlikView

Re: Scripting, adding a calculated field to a table

Mon, 09 Sep 2013 09:31:14 GMT

Thanks but still not working.

Looks like there must be a value in Formål_tmp in order for the join to work so I try to add a dummy value "<empty>" e.g. in stead

Re: Scripting, adding a calculated field to a table

SunilChauhan — Mon, 09 Sep 2013 09:37:54 GMT

Hi,

if( len(subfield(date&'/'&formaltmp,'/',2))=0,baerer,formal_tm) a Formal in script

hope this helps

Sunil

Re: Scripting, adding a calculated field to a table

Mon, 09 Sep 2013 09:42:06 GMT

Thanks but same result

Re: Scripting, adding a calculated field to a table

Sokkorn — Mon, 09 Sep 2013 09:42:29 GMT

Hi Jesper,

Did you try this yet:

If(Len(Formal_tmp)<1, Barrer, Formal_tmp) as Formal

Regards,

Sokkorn

Re: Scripting, adding a calculated field to a table

Mon, 09 Sep 2013 09:45:44 GMT

Yes and i didnt work. I even tried to just add a field: len(Formål_tmp) but it came up as a null value

Re: Scripting, adding a calculated field to a table

tresB — Mon, 09 Sep 2013 09:45:46 GMT

If your join key is Formal_tmp, it would not work. Because the NULL value can't be referred to take part in join. Rather you try to put this section(IF()..) of code in the earlier table(bugdetposter).

Re: Scripting, adding a calculated field to a table

Mon, 09 Sep 2013 09:47:49 GMT

my thought excactly. Thanks