Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavvibudagam
Creator II
Creator 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
Anonymous
Not applicable

Hi ,

Try Below





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

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

View solution in original post

7 Replies
tomasz_tru
Specialist
Specialist

Are those fields in the same table?

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

Tomasz

bhavvibudagam
Creator II
Creator II
Author

Hi,

Yes all these fields are coming from same qvd.

Thanks

tomasz_tru
Specialist
Specialist

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
Creator II
Creator II
Author

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
Specialist
Specialist

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable

Hi ,

Try Below





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

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