I am a new Qlik Sense user and am looking for a solution for the problem listed below.
I have a set of data comprising Purchase_Date, Item_Code, Invoice_Number and Price. The same item has multiple prices on the same date (against different invoice numbers).
I want to find the difference between the price listed in each invoice and the minimum price on that day. I tried to use the expression AGGR(MIN(price),item_code, purchase_date). This returns the value against the row having the lowest value. However it does not give any value in the other rows and hence I am unable to proceed further. Using RANGEMIN function also gave me a similar result.
I guess there's a simple solution; however its eluding me and I have not had any luck in finding it in the forum. Grateful for any help in this regard.