Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

Count if Distinct with a Set Modifier

Hiya

have a expression like this

count ( distinct  if([Target]<'35', Check_Number))

but  I want to add a set Modifier to it

I want to exclude customers from e.g  a country America

how would I please add this {$<[Country] ={"America"} >}

I try but my bars still shows for America as 0, but I want it to not appear

Kind Regards

4 Replies

Re: Count if Distinct with a Set Modifier

Hi Joana, can you try this?:

Count(DISTINCT {<[Country] ={"America"}, Target={"<35"}>} Check_Number)

joeybird
Contributor II

Re: Count if Distinct with a Set Modifier

Hiya

It don't work properly sorry needs the if

please help

Re: Count if Distinct with a Set Modifier

I think for excluding he would need a negative sign, right?

Count(DISTINCT {<[Country] -= {'America'}, Target={"<35"}>} Check_Number)

Re: Count if Distinct with a Set Modifier

or may be this:

Count(DISTINCT {<Country = e({<Country = {'America'}>}), Target={"<35"}>} Check_Number)

Community Browser