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



      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






      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