topic Re: set analysis with two conditions one excluding and one including in Connectivity & Data Prep

set analysis with two conditions one excluding and one including

Qlikuser09 — Mon, 28 Nov 2022 20:21:31 GMT

I want to ignore the purchase flag and include the present flag

Count({$-1<[Purchase FLAG]={'Y'}, Present Flag>}DISTINCT ID),

is not working

lblumenfeld — Tue, 29 Nov 2022 03:59:36 GMT

Your criteria looks reversed based upon what you're asking.

Are you trying to
- Ignore any selections made on Purchase Flag, and
- Require Present Flag to be a specific value?

If so then I'd use

Count({< [Present Flag]={"Y"}, Purchase Flag >}DISTINCT ID)

(Change the Y inside the double quotes to whatever value you're looking for.)

Qlikuser09 — Wed, 07 Dec 2022 05:18:21 GMT

if i have to ignore specific value purchase flag???

lblumenfeld — Wed, 07 Dec 2022 06:51:05 GMT

You mean Purchase Flag <> Y?

That would be this.

Count({< [Purchase Flag]-={"Y"} >}DISTINCT ID)

Note the “-“ in front of the equal. This means the selected values for Purchase Flag except for “Y”.

There are some other ways to do this when you want selections ignored, etc. @hic does a really good job of explaining it here. https://community.qlik.com/t5/Design/Excluding-values-in-Set-Analysis/ba-p/1471704