If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a number of "Products" sold by a number of "Customers" what i want to see is if a product is sold by more than one customer.
Data is as follows and I want to create the field "Multiple Sellers" via script
This should work:
[Table]:LOAD * INLINE [Customer,Product,Sales,Multiple Sellers1,Product A,5,Yes1,Product A,5,Yes1,Product B,5,Yes1,Product B,5,Yes1,Product C,5,Yes1,Product D,5,No1,Product D,5,No2,Product A,5,Yes2,Product B,5,Yes2,Product E,5,No2,Product E,5,No3,Product B,5,Yes3,Product C,5,Yes4,Product A,5,Yes4,Product A,5,Yes4,Product C,5,Yes];
LOADIF(Count(DISTINCT Customer) > 1,'Yes','No') AS [Multiple Sellers],ProductRESIDENT [Table]
GROUP BY Product;
View solution in original post
Almost had it ><.