My usual goto resource for Qlik stuff is away, so apologies for the really simple question. I've got a table below where I want to determine the average price for the each product, but also the minimum price. The table below is only a sample as the actual data is '000 of lines long.
My price is sum(Sales)/Sum(Qty). This works without issue, and aggregates the data under Product.
FirstSortedValue(distinct(Sales/Qty), SalesValue/Qty) should give me the minimum value, but it seems to be giving me 0, and I don't have any 0 values in my table.