6 Replies Latest reply: May 20, 2016 8:13 AM by Chris Waterworth RSS

    Finding the minium of an series of values

    Chris Waterworth

      Hi Qlik,

       

      I have a list of sites that each do a series of deliveries to mulitple destinations.

       

       

      I have a table set up with Source [Source Name] as the dimension showing the average cost avg[Total Cost] of delivery to each destination [Destination Name].

       

      Looking at opportunity cost I want to establish as a varible what the cheapest site to ship to is. However merely entering min(Total Cost) gives me back the cheapest delievry overall rather than the average of the site with lowest cost.

       

      Is there a way to create an array within the equation of average total cost to each site and then select the minimum average value?

       

      Regards,

       

      Chris