topic Max(LoadingDate) in QlikView

Max(LoadingDate)

pacoli2013 — Tue, 17 Jan 2017 16:32:13 GMT

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

Re: Max(LoadingDate)

sunny_talwar — Tue, 17 Jan 2017 16:36:03 GMT

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?

Re: Max(LoadingDate)

pacoli2013 — Wed, 18 Jan 2017 12:46:18 GMT

Hello Sunny,

I have made an example

I cannot send it here

Will try to add it to my first question

Regards Court

Re: Max(LoadingDate)

sunny_talwar — Wed, 18 Jan 2017 12:47:43 GMT

You can look here

Uploading a Sample

Re: Max(LoadingDate)

pacoli2013 — Wed, 18 Jan 2017 13:35:39 GMT

Thanks,

I have made a print of it

Court

Re: Max(LoadingDate)

stabben23 — Wed, 18 Jan 2017 13:59:50 GMT

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.