Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
droonu194
Contributor
Contributor

Multiple isnull() within an expression not working?

Hello,

I am trying to route my users to a specific website based on multiple isnull() conditions based on dates. I have roughly 6 dimensions I need to check. I've tried the len()>0 and =0 operation. I also tried if(isnull(Customer_Num1_DATE and Customer_Num2_DATE) but no luck.

example:

=if(isnull(Customer_Num1_DATE),
      if(isnull(Customer_Num2_DATE),

'www.newuser.com','www.updatedusers'))

Thank you.

 

Labels (1)
1 Solution

Accepted Solutions
BrunPierre
Master
Master

Hi, What about this or you could post some samples?

Len(Trim(Customer_Num1_DATE)) < 1

View solution in original post

3 Replies
BrunPierre
Master
Master

Hi, What about this or you could post some samples?

Len(Trim(Customer_Num1_DATE)) < 1

droonu194
Contributor
Contributor
Author

I've tried but it doesn't seem to evaluate it in the chart function.

=if(Len(Trim(1_date_created)) < 1,
if(Len(Trim(2_date_created)) < 1,
if(Len(Trim(3_date_created)) < 1,
if(Len(Trim(4_date_created)) < 1,
if(Len(Trim(5_date_created)) < 1,
if(Len(Trim(6_date_created)) < 1,
'Route to NEW Website','Route to old website'))))))

 

BrunPierre
Master
Master

Is this what you trying to do?

If(Len(Trim(1_date_created)) < 1 and Len(Trim(2_date_created)) < 1 and ...,'Route to NEW Website','Route to old website'))))))