Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rsingh43
Contributor

Qlik Expression help

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.   

Tags (1)
6 Replies
mtucholski
Contributor

Re: Qlik Expression help

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
Valued Contributor III

Re: Qlik Expression help

You may try the following:

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

mtucholski
Contributor

Re: Qlik Expression help

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

MVP
MVP

Re: Qlik Expression help

Where is this used? Calculated dimension or set analysis?

rsingh43
Contributor

Re: Qlik Expression help

Hi Sunny,

I am using this as a calculated dimension.

MVP
MVP

Re: Qlik Expression help

May be try this

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

Community Browser