Discussion Board for collaboration on QlikView Scripting.
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
Would you be able to share a few example of rows where you have changed stuff and how would you want to load this information?
I have made an example
I cannot send it here
Will try to add it to my first question
You can look here
Uploading a Sample
I have made a print of it
if you use incrementall load, save the load from where you fetch data With max(LoadingDate) as a New qvd.
then concatenate the New qvd with the previous qvd, the New qvd need to be first in script then the previous.
In the script where you load previous add where Exists (YourKey).
It will then find the value from New qvd where you have changed price or rates.
when it concatenate it With the old qvd the row With the same key is already there and will not add the second row.