topic Qlik Sense Set Expression - Multiple Conditions in App Development

Qlik Sense Set Expression - Multiple Conditions

QlikNewbie123 — Fri, 27 Nov 2020 05:07:09 GMT

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!

Re: Qlik Sense Set Expression - Multiple Conditions

agigliotti — Fri, 27 Nov 2020 10:55:18 GMT

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?

Re: Qlik Sense Set Expression - Multiple Conditions

QlikNewbie123 — Fri, 27 Nov 2020 21:39:24 GMT

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? 🙂