Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
I need to know how to delete null values of an expression not a dimension..
Thanks for your help
Have you saw or tried any of my solutions above?
MB
Can you share me your application
Yes. My expression is '= DATEE' I tried =If(DATEE <> 0, DATEE) / if (is not null (DATEE))
but it didn't work
Instead of zero try Null()
no. it doesn't work
If(DATEE <> Null() , DATEE)
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
I don't think so why is not working, Finally last chance from script.
Sheet1:
LOAD * FROM .....Excel Where DATEE;
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?