Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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
arunaerra
Partner
Partner

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

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)
arunaerra
Partner
Partner

Hi ,

Try Below





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

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

View solution in original post