Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

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
rubenmarin

Hi Joana, can you try this?:

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

joeybird
Creator III
Creator III
Author

Hiya

It don't work properly sorry needs the if

please help

sunny_talwar

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

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

sunny_talwar

or may be this:

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