My organisation would like to be able to monitor the development of status for records in our system. In our case we are talking about purchase orders that can have different statuses assigned throughout it's lifetime. But it could be anything like
Below and attached I have tried to display a simplified version of the table that we'll be using for the analysis (using DD-MM-YYYY):
In above example OrderID 10001 had status B on 04-08-2011. I would like to end up with a QlikView file where I can select Aug 4 and this OrderID and the status type B will be type of the selection.
Right now, I'm pretty clueless on how to set up the Calendar script on such a file. Anyone who can guide me in the right direction?
It's not quite what I'm looking for. In your example I can select Aug 4 and no corresponding data from the Log table is associated to it. I want to be able to create a snapshot on how the system looked on Aug 4 where the OrderID 10001 had status B.
Jakob, I think you must generate new data in you load script to solve your problem. There has to be a record with order 10001, status B and date 04-08-2011 for you to be able to click the way you want.
This data can be probably be generated by qlikview with the autogenerate function and a (few) loops, if not, it can be done in SQL at least.
Thanks for taking your time on this. I will play around with your suggestion and see if it can work for us. I'm a bit worried about the performance when used on a source table with more than 15 million records.