topic Re: mark changes vs previous export in QlikView

mark changes vs previous export

rutgerzwaal — Mon, 14 Dec 2015 15:40:51 GMT

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

Re: mark changes vs previous export

sinanozdemir — Mon, 14 Dec 2015 17:11:46 GMT

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.

Re: mark changes vs previous export

rutgerzwaal — Tue, 15 Dec 2015 09:15:22 GMT

Hi Sinan,

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