Set Analysis

[Purushothaman]

Hi Qlik Experts,

Requesting your help on the below problem statement.

Show count of Order ID in a KPI object for those Customers for whom the Sales is more than 1000 for the Order Date year 2012

Many Thanks.

[tresesco · Accepted solution]

May be this?

For those customers for all the years:

=Count(DISTINCT {<[Customer Name]={"=Sum({<[Order Year]={'2012'}>}Sales)>1000"}>}[Order ID])

For those customers  in 2012 only:

=Count(DISTINCT {<[Order Year]={'2012'},[Customer Name]={"=Sum({<[Order Year]={'2012'}>}Sales)>1000"}>}[Order ID])