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: 
Anonymous
Not applicable

Only one-to-one

Use Case:

EmployeeSalesRegion
A500Americas
B600Europe
B300Asia
B400Americas
C200Americas
C500Europe

In my Set analysis statement, I'm interested in Employees who made sales in Americas only. A above, discard B and C.

My set expressions is little complex and Only() doesn't seem to work, is there an alternate ?

Thank you.

1 Solution

Accepted Solutions
JonnyPoole
Employee
Employee

This will look at only the records with 'Americas' and the employees who have sold to one region

sum( {$<Region={'Americas'},Employee={"=count(distinct Region)=1"}>}  Sales)

View solution in original post

3 Replies
JonnyPoole
Employee
Employee

This will look at only the records with 'Americas' and the employees who have sold to one region

sum( {$<Region={'Americas'},Employee={"=count(distinct Region)=1"}>}  Sales)

Anonymous
Not applicable
Author

Thanks Jonathan.

I have another slightly different requirement.

Is it possible via Set Expression to look for Employees who made Sales in Europe and/or Asia but exclude all those who made Sales in America, even if they made in Europe and/or Asia.

JonnyPoole
Employee
Employee

You can using the e() function. I had to augment your sample but here is the result:

sum( {$<Employee=e( {1<Region={'Americas'}>})>} Sales)

Capture.PNG.png