Scripting, adding a calculated field to a table

[#1]

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

[tresesco]

Try this:

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

[Brice-SACCUCCI]

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

[#4]

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

[SunilChauhan]

Hi,

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

hope this helps

Sunil

[#6]

Thanks but same result

[Sokkorn]

Hi Jesper,

Did you try this yet:

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

Regards,

Sokkorn

[#8]

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

[tresesco · Accepted solution]

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).

[#10]

my thought excactly. Thanks