topic Re: Daily fact table loads... in QlikView https://community.qlik.com/t5/QlikView/Daily-fact-table-loads/m-p/1203390#M387084 <HTML><HEAD></HEAD><BODY><P>Shouldn't this be done by tracking something like 'OrderDate'?</P><P></P><P>Or maybe I just don't understand what you are after and how your data looks like...</P></BODY></HTML> Wed, 05 Oct 2016 17:29:38 GMT swuehl 2016-10-05T17:29:38Z Daily fact table loads... https://community.qlik.com/t5/QlikView/Daily-fact-table-loads/m-p/1203389#M387083 <HTML><HEAD></HEAD><BODY><P>What is best/recommended method to handle loading facts from day to day?</P><P></P><P>For example, orders and order detail is loaded for a customer but the next day there are no new orders and we want to trend order activity from day to day.</P><P></P><P>I don't want to duplicate all the old facts again but we want to see the trend "flatline"</P><P></P><P>If one day I get 100 new orders I want to see that spike in the trendline.</P></BODY></HTML> Wed, 05 Oct 2016 17:12:31 GMT https://community.qlik.com/t5/QlikView/Daily-fact-table-loads/m-p/1203389#M387083 markp201 2016-10-05T17:12:31Z Re: Daily fact table loads... https://community.qlik.com/t5/QlikView/Daily-fact-table-loads/m-p/1203390#M387084 <HTML><HEAD></HEAD><BODY><P>Shouldn't this be done by tracking something like 'OrderDate'?</P><P></P><P>Or maybe I just don't understand what you are after and how your data looks like...</P></BODY></HTML> Wed, 05 Oct 2016 17:29:38 GMT https://community.qlik.com/t5/QlikView/Daily-fact-table-loads/m-p/1203390#M387084 swuehl 2016-10-05T17:29:38Z Re: Daily fact table loads... https://community.qlik.com/t5/QlikView/Daily-fact-table-loads/m-p/1203391#M387085 <HTML><HEAD></HEAD><BODY><P>Maybe you are looking for something like an Incremental LOAD approach?</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">Using QVD files for incremental load ‒ QlikView</A></P></BODY></HTML> Wed, 05 Oct 2016 17:38:37 GMT https://community.qlik.com/t5/QlikView/Daily-fact-table-loads/m-p/1203391#M387085 swuehl 2016-10-05T17:38:37Z Re: Daily fact table loads... https://community.qlik.com/t5/QlikView/Daily-fact-table-loads/m-p/1203392#M387086 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I should be supriced if the ordertabel dont contain some kind of status on the order. You should here see when (date) the status is changed on every order.</P></BODY></HTML> Wed, 05 Oct 2016 18:05:39 GMT https://community.qlik.com/t5/QlikView/Daily-fact-table-loads/m-p/1203392#M387086 stabben23 2016-10-05T18:05:39Z