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


    Court van de Lisdonk



      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