Null() help

[bhavvibudagam]

Hi Experts,

Can any one please help me on below requirement.

I have two fields called PRODUCT1 and PRODUCT2 contains blank and null values.

I have convert these values into Null Text.

I have tried

NULLASVALUE "PRODUCT1","PRODUCT2";

SET NULLVALUE = 'NULL';

But i am not able to see NULL text in the above fields.

Please help me on this.

Thanks in advance.

[tomasz_tru]

Are those fields in the same table?

If those nulls occur on-the-fly on application level, script entries won't help.

Tomasz

[bhavvibudagam]

Hi,

Yes all these fields are coming from same qvd.

Thanks

[tomasz_tru]

If the fields are joined together into one table in Qlik model then NULLASVALUE will work. But when we just have association between them nulls will be still nulls in the visualization.

[bhavvibudagam]

Hi Tomasz,

Thanks for your reply. Unfortunately this qvd is associated with other qvds using left keep. Is there any way to convert these nulls in UI.

[tomasz_tru]

I wish i know There are tricks with LEN function or using ={"*"} in set analysis but it never worked for me. I would join those tables in application script if it wouldn't affect the data.

[Anil_Babu_Samineni]

Script is same for both, Not sure your intend to create same thread in 2 environments Null Help

[Anonymous · Accepted solution]

Hi ,

Try Below

If(len(trim(Product1))= 0, Null(), Product1)

=If(len(trim(Product2))= 0, Null(), Product2)