Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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?
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? 🙂