Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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/...
You may try the following:
=if(Exp_PODDate <> today() and Not (isnull(Exp_PODDate)),Exp_PODDate)
Please mark the post as a solution if it served you.
Where is this used? Calculated dimension or set analysis?
Hi Sunny,
I am using this as a calculated dimension.
May be try this
=If(Exp_PODDate <> Today() or Len(Trim(Exp_PODDate)) > 0, Exp_PODDate)
