topic Compare Snapshot Data in QlikView https://community.qlik.com/t5/QlikView/Compare-Snapshot-Data/m-p/745959#M1030434 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the attached Document, not sure the best way to do this but each month I take a snapshot of a table telling me the position of aged orders and the amount it is.</P><P>I then insert into the same table each day the latest Aged Orders and what the amount is. </P><P>What I want is for the Range field to always be selected from the table where the Type = "Start" which is when the data was first loaded in for that month.</P><P>If that ID has moved to another Range I still want it to show Amount it is for the "Start" Range.</P><P>Hopefully I have made myself clear?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 18 Feb 2015 15:14:52 GMT ivandrago 2015-02-18T15:14:52Z Compare Snapshot Data https://community.qlik.com/t5/QlikView/Compare-Snapshot-Data/m-p/745959#M1030434 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the attached Document, not sure the best way to do this but each month I take a snapshot of a table telling me the position of aged orders and the amount it is.</P><P>I then insert into the same table each day the latest Aged Orders and what the amount is. </P><P>What I want is for the Range field to always be selected from the table where the Type = "Start" which is when the data was first loaded in for that month.</P><P>If that ID has moved to another Range I still want it to show Amount it is for the "Start" Range.</P><P>Hopefully I have made myself clear?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 18 Feb 2015 15:14:52 GMT https://community.qlik.com/t5/QlikView/Compare-Snapshot-Data/m-p/745959#M1030434 ivandrago 2015-02-18T15:14:52Z