Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)