Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

pacoli2013
Contributor

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
MVP
MVP

Re: Max(LoadingDate)

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
Contributor

Re: Max(LoadingDate)

Hello Sunny,

I have made an example

I cannot send it here

Will try to add it to my first question

Regards Court

MVP
MVP

Re: Max(LoadingDate)

You can look here

Uploading a Sample

pacoli2013
Contributor

Re: Max(LoadingDate)

Thanks,

I have made a print of it

Court

stabben23
Honored Contributor

Re: Max(LoadingDate)

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.

Community Browser