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: 
Not applicable

Attempt to narrow down what needs attention using isnull

Hello community,

I'm working on an expression to help narrow down when my colleagues miss a step in the process.

Basically if Step 3 is complete (not Null), but either step 1 or 2 is not (Null) work needs to be down.

=count(DISTINCT if([Load Date]=vLatestDate AND Isnull([Step1- Actual]) AND IsNull ([Step2 - Actual]) , [Project Number]))

works in providing me with situations where Step1 or 2 are null.

However, I'm not sure how I can ask the question to include Step3 is not Null.

Any advice on this?

Regards,

Myles

1 Solution

Accepted Solutions
maxgro
MVP
MVP

and not isnull(step3)

and len(trim(step3))>0

View solution in original post

3 Replies
maxgro
MVP
MVP

and not isnull(step3)

and len(trim(step3))>0

ramoncova06
Specialist III
Specialist III

just to add to Massimo reply

isnull(step3) = 0

sunny_talwar

I thought you wanted step 1 or step 2 to be null, but your expression is saying and. Are you looking for this:

=Count(DISTINCT If([Load Date]=vLatestDate and Len(Trim(Step3)) >0 and (Isnull([Step1- Actual]) or IsNull([Step2 - Actual])), [Project Number]))


Best,

Sunny