topic Re: Compare 2 or more historical fields for tracking purposes in QlikView

Compare 2 or more historical fields for tracking purposes

Mon, 13 Jun 2011 07:11:04 GMT

Hi,

I need some help comparing tables and outputting the differenses to track changes. I store away all orders with ordernumbers, orderrows and productid every day 5 days back and delete anything older. I need to load all these files and compare them to one another and present the changed orderrows in a chart.

If the loaded table has this in it:

Savedate Orderdate Ordernbr Row ProductID Qty

110501 110301 12345 10 5555 4

110503 110301 12345 10 4444 4

Then that change should be visible in the chart

Although theese two rows:

Savedate Orderdate Ordernbr Row ProductID Qty

110511 110401 15555 10 3333 3

110513 110401 15555 10 3333 3

Would'nt generate any output in the cart

So basically: I want to compare a row with every other row with different SaveDates and see if there is any changes in Qty or/and ProudctID. If there is, show it in a chart.

How would the expression for doing this look like? I'm feeling very stuck with this

Compare 2 or more historical fields for tracking purposes

Fri, 08 Jul 2011 16:34:26 GMT

Hi jonas_bringberger,

I hope I am lucky to find this post. I was wondering if you found

any solution to this problem. I shall be ever grateful if you could please

explain to solve such issue.

Thanks & Regards,

Bikash

Re: Compare 2 or more historical fields for tracking purposes

johnw — Sat, 09 Jul 2011 00:06:20 GMT

This looks like a fairly similar requirement to a couple examples I've made. One shows comparing data across three different months. It shows ALL the data, and highlights differences. The other shows comparing data across two different tables. It removes rows that are the same in both tables, and highlights differences.

Re: Compare 2 or more historical fields for tracking purposes

Tue, 26 Jul 2011 12:24:25 GMT

Thanks!

Although I still can't get it to work. I have a few more dimensions. The load script looks like this

for each File in filelist ('c:\History\*.qvd')

Orders_temp:

ADD LOAD

ArticleNumber,

Qty,

date(SaveDate,'YYMMDD') as SaveDate, // when this file was saved

Ordernumber,

Rownumber

FROM $(File) (qvd);

next File

We can assume that Ordernumber and Rownumber is static. I then want to compare which Articlenumbers and/or Qty:s are changed in each Ordernumer/Rownumber for each SaveDate

Re: Compare 2 or more historical fields for tracking purposes

farolito20 — Wed, 19 Dec 2012 15:28:52 GMT

Do you found a solution?

I have the same problem 😕