Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Santosh
Contributor III
Contributor III

Find out Salesperson who made sales in more then one country( Set Analysis)

Hi

i want to find out the Salesperson who made the sales in multiple  country.

my table

Capture123.JPG

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe like

Sum({<SalesPerson1 = {"=Count(DISTINCT CustomerCountry)>1"}>} salesss)

View solution in original post

4 Replies
swuehl
MVP
MVP

Maybe like

Sum({<SalesPerson1 = {"=Count(DISTINCT CustomerCountry)>1"}>} salesss)

Santosh
Contributor III
Contributor III
Author

Hi Stefan

I have one more question

supposes i have list of country and i want find the salesperson who made sales in Argentina and also in Austria .

swuehl
MVP
MVP

Maybe using p() function and intersection operator

=Sum(

{<SalesPerson1 = p({<CustomerCountry = {'Argentina'}>}) * p({<CustomerCountry = {'Austria'}>}) >}

salesss)

or using an expression search

Sum(

{<SalesPerson1 =

{" =Sum( {<CustomerCountry = {'Argentina'}>} salesss) > 0

and Sum({<CustomerCountry = {'Austria'}>}salesss) >0"}

>}

salesss)

Santosh
Contributor III
Contributor III
Author

Thanks Stefan