Qlik Expression help

[Anonymous]

Hi,

Can someone please assist with the below expression? It does not seem to be working:

=if(Exp_PODDate <> today() or isnull(Exp_PODDate),Exp_PODDate)

I need to exclude any Exp_PODDate that have the same date as today or are null. 

Thanks in advance.   

[mtucholski]

Hello, try this:

=if(Exp_PODDate <> today() or isnull(Exp_PODDate)=-1,Exp_PODDate)

The IsNull function tests if the value of an expression is NULL and if so, returns -1 (True), otherwise 0 (False).

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/NULLFunctions/...

[nagaiank]

You may try the following:

=if(Exp_PODDate <> today() and Not (isnull(Exp_PODDate)),Exp_PODDate)

[mtucholski]

Please mark the post as a solution if it served you.

[sunny_talwar]

Where is this used? Calculated dimension or set analysis?

[Anonymous]

Hi Sunny,

I am using this as a calculated dimension.

[sunny_talwar]

May be try this

=If(Exp_PODDate <> Today() or Len(Trim(Exp_PODDate)) > 0, Exp_PODDate)