is null function in qliksense

[Anonymous]

HI

i need  to create a column as

where ever A column data is null then i should be getting value of A and if A columns data is not null then i should get A columns data only.

For that i used isnul function but seems it is not bring data what i requeired

can anyone please help here

i used

if(IsNull(A),B,A)

Thanks

[sunny_talwar]

Can you share your script where you doing this and images with

LOAD IsNull(A),

     Len(Trim(A)),

     A,

     B

FROM ...

[Anonymous]

Below is the script syntax:

load A,B;

SQL SELECT A,B from table1;

[sunny_talwar]

Screenshot of a table using this script

LOAD IsNull(A),

     Len(Trim(A)),

     A,

     B

FROM ...

[Anonymous · Accepted solution]

This worked for me

If((Trim(if(A='null','0'))) = '0',B, A)

[sunny_talwar]

Great