13 Replies Latest reply: Sep 25, 2017 12:49 AM by Apoorva Dhulehole RSS

    Firstsortedvalue function with sum in QlikView

    Apoorva Dhulehole

      Hello Everyone,

       

      I am using firstsortedvalue function to pick up last value in date field for a particular month. But I would like to combine this with sum function. What I want is, in the attached example, when more than two plants are selected, my graph should display value which is the sum of last value of date field of that particular month combining both plants (sum). How can I achieve this?

       

      Any suggestion?

       

      Thank you.