topic Re: Data Historization in QlikView https://community.qlik.com/t5/QlikView/Data-Historization/m-p/490788#M183362 <HTML><HEAD></HEAD><BODY><P>This blog post may help: <A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions" style="font-style: inherit; font-family: inherit; color: #3d3d3d;">Slowly Changing Dimensions</A></P></BODY></HTML> Fri, 18 Oct 2013 16:35:48 GMT Gysbert_Wassenaar 2013-10-18T16:35:48Z Data Historization https://community.qlik.com/t5/QlikView/Data-Historization/m-p/490787#M183361 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am looking for some advise on how to approach Data Hostorization in QlikView.</P><P></P><P>Currently in my Database I have a History table that list changes to Order line Prices. The History Table date stamps when these changes take place e.g.</P><P></P><P>Order Line No: N12345</P><P>Price: 100</P><P>Price Change: 110</P><P>Date: 01/09/13</P><P></P><P>Order Line No: N12345</P><P>Price: 110</P><P>Price Change: 115</P><P>Date: 01/10/13</P><P></P><P>Therefor when I look at my data today, Order Line No: N12345 is showing a Price of 115 which is correct. However I have a requirement to look at these changes over time and report the Price over a selected time e.g.</P><P></P><P>For Sept 2013 - I would expect to see Order Line No: N12345 showing a Price of 110</P><P>For Oct 2013 - I would expect to see Order Line No: N12345 showing a Price of 115</P><P></P><P>Please can you advise how this can be done is QlikView?</P><P></P><P>Kind Regards,</P><P>Nikki</P></BODY></HTML> Fri, 18 Oct 2013 15:02:11 GMT https://community.qlik.com/t5/QlikView/Data-Historization/m-p/490787#M183361 2013-10-18T15:02:11Z Re: Data Historization https://community.qlik.com/t5/QlikView/Data-Historization/m-p/490788#M183362 <HTML><HEAD></HEAD><BODY><P>This blog post may help: <A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions" style="font-style: inherit; font-family: inherit; color: #3d3d3d;">Slowly Changing Dimensions</A></P></BODY></HTML> Fri, 18 Oct 2013 16:35:48 GMT https://community.qlik.com/t5/QlikView/Data-Historization/m-p/490788#M183362 Gysbert_Wassenaar 2013-10-18T16:35:48Z