Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
I've attached an example with 4 weeks of exports.
Lets say i want to know:
All ideas are welcome.
Best regards,
Rutger
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:
table : evolution between 2 dates
Hope these help.
Hi Sinan,
Thank you for your reply. I will have a look this afternoon.