topic Re: How to get historical data in QlikView https://community.qlik.com/t5/QlikView/How-to-get-historical-data/m-p/1360116#M416989 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>May be like at attached file? Autogenerate a large number that would load lasted at least 1-2 seconds.</P><P></P><P>Regards,</P><P>Andrey</P></BODY></HTML> Mon, 24 Jul 2017 15:00:46 GMT ahaahaaha 2017-07-24T15:00:46Z How to get historical data https://community.qlik.com/t5/QlikView/How-to-get-historical-data/m-p/1360115#M416988 <HTML><HEAD></HEAD><BODY><P>Hey there,</P><P></P><P>i want to get a history of my data. E.g. the data of my table "xyz"&nbsp; on the reload date 23.07.2017 is like that:</P><P></P><P>orderID amount</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P></P><P>tomorrow the 24.07.2017 its:</P><P></P><P>orderID amount</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 240</P><P></P><P>I want to get a master qvw which i can use to get graphs about the development of the amount sorted by id. The Master qvw looks like this:</P><P></P><P>orderID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reload date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reload time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; amount</P><P></P><P></P><P>Anyone got a plan or at least know where to find a guide...</P><P></P><P>Many thanks in advance </P></BODY></HTML> Mon, 24 Jul 2017 13:10:48 GMT https://community.qlik.com/t5/QlikView/How-to-get-historical-data/m-p/1360115#M416988 bmensing 2017-07-24T13:10:48Z Re: How to get historical data https://community.qlik.com/t5/QlikView/How-to-get-historical-data/m-p/1360116#M416989 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>May be like at attached file? Autogenerate a large number that would load lasted at least 1-2 seconds.</P><P></P><P>Regards,</P><P>Andrey</P></BODY></HTML> Mon, 24 Jul 2017 15:00:46 GMT https://community.qlik.com/t5/QlikView/How-to-get-historical-data/m-p/1360116#M416989 ahaahaaha 2017-07-24T15:00:46Z Re: How to get historical data https://community.qlik.com/t5/QlikView/How-to-get-historical-data/m-p/1360117#M416990 <HTML><HEAD></HEAD><BODY><P>Halle,</P><P></P><P>this looks like you need an incermental load.</P><P></P><P>I think this links should help you. </P><P><A href="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/QVD_Incremental.htm" title="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/QVD_Incremental.htm">http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/QVD_Incremental.htm</A></P><P><A href="https://community.qlik.com/docs/DOC-5508">Incremental Load.docx</A></P><P></P><P>Best regards</P><P></P><P>Sebastian</P></BODY></HTML> Mon, 24 Jul 2017 15:04:11 GMT https://community.qlik.com/t5/QlikView/How-to-get-historical-data/m-p/1360117#M416990 sebastianlettner 2017-07-24T15:04:11Z