13 Replies Latest reply: Mar 15, 2016 7:25 AM by Moreira Carlos RSS

    How to get the last value from a product in time

    Moreira Carlos

      Hello,

       

      I am dealing with a problem for some time now and I can't find a solution that might be easy for you.

       

      The problem seems simple but I am still a beginner in QlikView.

       

      The situation is as follows:

       

      I have a dataset with 4 months of data. In this period of time the quantity of products changed.

       

      What I want is to get is the last quantity.

      Imagine this, if I am looking for this last 4 months of data and the product 12345678

       

      MonthProductQty
      11234567810
      212345678

      -5

      31234567810
      4123456785

       

      I want to get the Qty = 5 for example in a TextBox.

       

      I have tried the firstSortedValue but it is not returning the value I expected.

       

      Please see attached file.

       

      Thanks very much