So I have a list of products being sold. I need to find the top selling product. I have 5 excel charts which I loaded into Qlikview (Categories,Order Details,Products,Order Header,Customer). From the Product's excel I have about 70 or so product IDs and as you can see different quantity's are being sold. How do I group all the ProductID 1 with all its sales and Products ID 2 .... so I can find the top selling product ?
I created a chart and added "productId" and "quantity" but I am pretty sure that's not the way it is supposed to look as it gives for every different transaction its own bar. For the Expression I wrote smth like "MaxString Quantity" Which I am sure is not the correct way. I have attached this bar chart as well.