mark changes vs previous export

[rutgerzwaal]

Hi,

We work with weekly exports from our client data system.

In this export we have several fields that can change in time.

I'm looking for a nice way to indicate the changes vs a previous export.

The fields that can change are:

• Client: a new client can be added that was not in the previous exports
• Status
• Volume
• Price

I've attached an example with 4 weeks of exports.

Lets say i want to know:

• what are the new contracts in week 4 vs week 2
• are there contracts that have a different volume in week 4 vs week 2

All ideas are welcome.

Best regards,

Rutger

[sinanozdemir]

Hi,

I wasn't quite sure if you only wanted to compare the new contracts for each client. Since there is no contract ID, I am assuming that you want to compare the first new contract. If so, here is what I have as a suggestion:

And then in a straight table, you can put an expression to compare the first contracts:

I feel like this is not what you are looking for, but I am attaching the qvw which may give you an idea.

You can also take a look at the below threads which I also contributed:

Current vs. previous year

table : evolution between 2 dates

Hope these help.

[rutgerzwaal]

Hi Sinan,

Thank you for your reply. I will have a look this afternoon.