Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
MVP
MVP

Re: Attempt to narrow down what needs attention using isnull

and not isnull(step3)

and len(trim(step3))>0

3 Replies
MVP
MVP

Re: Attempt to narrow down what needs attention using isnull

and not isnull(step3)

and len(trim(step3))>0

ramoncova06
Valued Contributor III

Re: Attempt to narrow down what needs attention using isnull

just to add to Massimo reply

isnull(step3) = 0

Re: Attempt to narrow down what needs attention using isnull

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

Community Browser