Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Compare 2 or more historical fields for tracking purposes

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

4 Replies
Not applicable
Author

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

johnw
Champion III
Champion III

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.

Not applicable
Author

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

farolito20
Contributor III
Contributor III

Do you found a solution?

I have the same problem 😕