3 Replies Latest reply: Mar 27, 2015 11:20 AM by Tim Gallagher RSS

    Load data from two different dates side by side?

    Matt Maino

      Hi all,

       

      I am working with a qlikview document that is loading data from several qvd files - each with the same fields, but separated by date. In my data model I am joining all of these qvd files into one main table that contains data from all the dates. What I would like to do is be able to view the change in a certain field value from one date to another. For example - I would like to display the balances of all accounts on Feb 28 and next to that the balances for the same accounts on Jan 31 and then the difference between the two values. The only way that I have been able to successfully do this is by creating a new table in my data model that pulls data for the previous month (with different names for all of the fields). I have the feeling that there is a better method to accomplish this. Does anybody have suggestions?

       

      Thank you!