Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alextomlins
New Contributor II

Help?! ISNULL with expressions!?

Hi Guys,

I have a list of subscribers - All of them have start dates but only some have end dates depending on whether they have unsubscribed or not.

So for those that have not unsubscribed and have a null i would like to replace the null with the current date - and then calculate the number of days between the startdate and 'end date' '

So far i have ;

If(IsNull([UnsubscribeDateTime]),Today(), [UnsubscribeDateTime]) - [SubscribedDateTime]

The issue I'm having is the False part of the If statement - it's coming back as a blank. It works when replacing the null with the current date but does not give me the number of days for those that do have an unsub date strangely.

PLease help  

6 Replies
YoussefBelloum
Esteemed Contributor

Re: Help?! ISNULL with expressions!?

can you share a part of your data ?

Re: Help?! ISNULL with expressions!?

Is your date and time field read correctly as a date and time field with numeric underlying value?

Why don’t my dates work?

QlikView Date fields

Get the Dates Right

OmarBenSalem
Esteemed Contributor

Re: Help?! ISNULL with expressions!?

try If(len(trim([UnsubscribeDateTime]))=0 ,Today(), [UnsubscribeDateTime]) - [SubscribedDateTime]

alextomlins
New Contributor II

Re: Help?! ISNULL with expressions!?

Hi Guys - I've now fixed this - There were two tables that get concatenated so I had to put the function into both of the loads   Thank you for your help

alextomlins
New Contributor II

Re: Help?! ISNULL with expressions!?

Hi Guys - I've now fixed this - There were two tables that get concatenated so I had to put the function into both of the loads   Thank you for your help

alextomlins
New Contributor II

Re: Help?! ISNULL with expressions!?

Hi Guys - I've now fixed this - There were two tables that get concatenated so I had to put the function into both of the loads   Thank you for your help

Community Browser