Qlik Sense Set Expression - Multiple Conditions

[QlikNewbie123]

Hi all,

I'm stuck trying to put multiple conditions in a set analysis expression. What I am trying to do is only count those that aren't Ended AND CRP - Final Admin, but in two scenarios (EndDateFlag and OldReviewEndDateFlag).

I can't seem to get the AND and OR conditions correct.

Count({<[EndDateFlag] -= {'Ended'},[Review.Active_Task_Name] -= {'CRP - Final Admin'}>

+

<[OldReviewEndDateFlag]-={'Ended'},[Review.Active_Task_Name] -= {'CRP - Final Admin'}>}

distinct[Review.ID])

I appreciate any help!

[agigliotti]

Hi @QlikNewbie123 ,

Your expression logically is doing as below:
...
Where [Review.Active_Task_Name] <> 'CRP - Final Admin'   AND (  [EndDateFlag] <> 'Ended'  OR [OldReviewEndDateFlag] <> 'Ended' )

Is this what are you looking for?

[QlikNewbie123]

So basically...

(Where EndDateFlag <> Ended AND Active Task Name <> CRP Final Admin) OR (Where OldReviewEndDateFlag <> Ended AND Active Task Name <> CRP Final Admin), then count distinct[Review.ID]

does that make it clearer? 🙂