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

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

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

1 Reply
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)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)