null values

[master_student]

Hello guys,

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

Thanks for your help

[miguelbraga]

Have you saw or tried any of my solutions above?

MB

[Anil_Babu_Samineni]

Can you share me your application

[master_student]

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()

[master_student]

no. it doesn't work

If(DATEE <> Null() , DATEE)

[miguelbraga]

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;

[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?