Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

null values

Hello guys,

I need to know how to delete null values of an expression not a dimension..

Thanks for your help

17 Replies
miguelbraga
Partner - Specialist III
Partner - Specialist III

Have you saw or tried any of my solutions above?

MB

Anil_Babu_Samineni

Can you share me your application

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
master_student
Creator III
Creator III
Author

Yes. My expression is '= DATEE' I tried =If(DATEE <> 0, DATEE) / if (is not null (DATEE))

but it didn't work

Anil_Babu_Samineni

Instead of zero try Null()

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
master_student
Creator III
Creator III
Author

no. it doesn't work

If(DATEE <> Null() , DATEE)

miguelbraga
Partner - Specialist III
Partner - Specialist III

Clearly you didn't read my solution but here it goes...

Try this:

=If(isnull(DATEE), null(), DATEE)

This should give you the ability to see where the null is and only then surpress it in the Presentation Tab

Best regards,

D.A. MB

Anil_Babu_Samineni

I don't think so why is not working, Finally last chance from script.

Sheet1:

LOAD * FROM .....Excel  Where DATEE;

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

Do you have other expressions in the field where you are not using the same if function which you use for this particular expression? Also what version of QlikView are you using?