Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pacoli2013
Creator
Creator

Max(LoadingDate)

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

5 Replies
sunny_talwar

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?

pacoli2013
Creator
Creator
Author

Hello Sunny,

I have made an example

I cannot send it here

Will try to add it to my first question

Regards Court

sunny_talwar

You can look here

Uploading a Sample

pacoli2013
Creator
Creator
Author

Thanks,

I have made a print of it

Court

stabben23
Partner - Master
Partner - Master

Hi,

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.