Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bhavvibudagam
Contributor II

Null() help

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.

1 Solution

Accepted Solutions
arunaerra
Contributor

Re: Null() help

Hi ,

Try Below





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

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

7 Replies
tomasz_tru
Valued Contributor

Re: Null() help

Are those fields in the same table?

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

Tomasz

bhavvibudagam
Contributor II

Re: Null() help

Hi,

Yes all these fields are coming from same qvd.

Thanks

tomasz_tru
Valued Contributor

Re: Null() help

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
Contributor II

Re: Null() help

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
Valued Contributor

Re: Null() help

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.

Re: Null() help

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

arunaerra
Contributor

Re: Null() help

Hi ,

Try Below





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

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