Discussion board where members can get started with QlikView.
Need find the Best Color with the highest Sold Qty for each Product.
What i did is,
used below expression and able to get the best color by product wise
If two color in same rank then it's showing null. is there anyway to resolve it? or just show any of one color instead of null?
=Concat(DISTINCT Aggr(If(Sum(SoldQty) = Max(TOTAL <Product> Aggr(Sum(SoldQty), Product, Color)), Color), Product, Color), ', ')
View solution in original post
For any one color, you can use FirstSortedValue() function with DISTINCT
Also you can try the below expression: ( One of Sunny's post inspired me with this expression ). Hope this helps...
=firstsortedvalue(Color,-aggr(sum(SoldQty) + Rank([Color])/1E10,Product,Color))