topic Re: Stock value in QlikView https://community.qlik.com/t5/QlikView/Stock-value/m-p/1329803#M834851 <HTML><HEAD></HEAD><BODY><P>Store the history in a qvd file - it will save and load much faster than a text file. If the data set is large (millions of rows), then you may need to use an incremental load approach. You could check out the reference manual for "incremental loading" or search here.These blog postings should help </P><P></P><P><A href="https://community.qlik.com/docs/DOC-8844">Get started with developing qlik datamodels</A></P><P><A href="https://community.qlik.com/docs/DOC-9038">Advanced topics for creating a qlik datamodel</A></P><P><A href="https://community.qlik.com/docs/DOC-9040">More advanced topics of qlik datamodels</A></P><P></P><P>Also make sure that you add a calendar to your model. This will make both the selection and the expressions for this analysis much easier. Search here for "master calendar" for more information. The following will also help:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-8843">How to use - Master-Calendar and Date-Values</A></P><P></P><P>If you would like more specific help, I suggest you provide more information about your data model and preferably, upload small sample qvw and/or xlsx files.</P></BODY></HTML> Mon, 29 May 2017 06:27:57 GMT jonathandienst 2017-05-29T06:27:57Z Stock value https://community.qlik.com/t5/QlikView/Stock-value/m-p/1329801#M834849 <HTML><HEAD></HEAD><BODY><P>Howe is the best way to save stock value ?</P><P>I have a lots a of parts whit quantity and value in a txt file thats loads into qw.</P><P>so i can calculate the stock value... <SPAN style="font-size: 13.3333px;">quantity * value and take the sum of that .....</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">But now i wont to compare the stock value from month to month, veek to veek. or day to day depend of the file size of qw grows</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">So i want to save the Date(Today), partsnumber, stockvalue evry (month, veek or day) in qw (or txt file to load).<BR /></SPAN>Can somboby help me too explan howe too do that the best way </P><P></P><P>/ Leif</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Stock-value/m-p/1329801#M834849 2020-11-25T16:16:04Z Re: Stock value https://community.qlik.com/t5/QlikView/Stock-value/m-p/1329802#M834850 <HTML><HEAD></HEAD><BODY><P>Can somone help me too save same calcultated values too a table (file) som i can compare stoch value per date.</P></BODY></HTML> Mon, 29 May 2017 05:39:24 GMT https://community.qlik.com/t5/QlikView/Stock-value/m-p/1329802#M834850 2017-05-29T05:39:24Z Re: Stock value https://community.qlik.com/t5/QlikView/Stock-value/m-p/1329803#M834851 <HTML><HEAD></HEAD><BODY><P>Store the history in a qvd file - it will save and load much faster than a text file. If the data set is large (millions of rows), then you may need to use an incremental load approach. You could check out the reference manual for "incremental loading" or search here.These blog postings should help </P><P></P><P><A href="https://community.qlik.com/docs/DOC-8844">Get started with developing qlik datamodels</A></P><P><A href="https://community.qlik.com/docs/DOC-9038">Advanced topics for creating a qlik datamodel</A></P><P><A href="https://community.qlik.com/docs/DOC-9040">More advanced topics of qlik datamodels</A></P><P></P><P>Also make sure that you add a calendar to your model. This will make both the selection and the expressions for this analysis much easier. Search here for "master calendar" for more information. The following will also help:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-8843">How to use - Master-Calendar and Date-Values</A></P><P></P><P>If you would like more specific help, I suggest you provide more information about your data model and preferably, upload small sample qvw and/or xlsx files.</P></BODY></HTML> Mon, 29 May 2017 06:27:57 GMT https://community.qlik.com/t5/QlikView/Stock-value/m-p/1329803#M834851 jonathandienst 2017-05-29T06:27:57Z