List of customers that do NOT buy the selected products (for some selected Sales Reps and Time)

[Anonymous]

Hi,

We have the dimensions: TIME, PRODUCT, SALES REP AND CUSTOMERS

When the user selects a Period of time, a Sales Rep and a Product wants to know the Customers that the selected vendor DID NOT sells the selected product at the selected time.

  That is, the user DOES NOT want the list of all customers who do not meet the condition but only include THEIR customers (those who sold at least 1 time and who have NOT purchased the selected product in the selected period).

Thanks in advance

[Anil_Babu_Samineni]

Normally, The Qlik associate can show only there period of time. Perhaps this?

Count({<TIME = {">=$(=Interval(Min(TIME),'hh:mm:ss')) <=$(=Interval(Max(TIME),'hh:mm:ss'))"}>} CUSTOMERS)