3 Replies Latest reply: Sep 14, 2017 11:04 AM by Apoorva Dhulehole RSS

    FirstSortedValue function isn't considering negative values in the field

    Apoorva Dhulehole

      Hello Everyone,

       

      I am using FirstSortedValue function in QlikView to pick up last value of a particular month in a field. The issue is, when the last value of a field in that particular month is negative, then the function is picking up next last value which is a positive number.

       

      Of course there is a condition in the expression to pick up values greater than 0, but if i remove the condition, the graph doesn't display anything?

       

      Any help on this?

       

      Attached is the sample.

       

      Thank you.