5 Replies Latest reply: Jan 18, 2017 8:59 AM by Staffan Johansson RSS

    Max(LoadingDate)

    Court van de Lisdonk

      Hello,

       

      I have a QVD SalesOrders with different LoadingDates.

      I only need the last LoadingDate for my Dashboard.

       

      Problem is that some fields like (UnitPrice, ExchangeRate) have changes between the Loadingdates

       

      So when I Load my QVD with in the script 'Max(LoadingDate) as LoadingDate, I get two records because Qlikview sees both LoadingDates as unique records because the changes.

       

      I loaded the records without the fields that have been changed, the works better, but second Problem is that I Need the Content of some 'changed' fields.

       

      I hope someone can help me,

       

      Thanks in advance

       

      Court