topic Re: Historical number in QlikView https://community.qlik.com/t5/QlikView/Historical-number/m-p/744003#M472809 <HTML><HEAD></HEAD><BODY><P>I know how much is in stock now , for example, 50000 pcs . Last week , it fell by 5,000 pieces and the week before that , it increased by 10,000 pcs .</P></BODY></HTML> Tue, 16 Dec 2014 10:13:58 GMT johanlind 2014-12-16T10:13:58Z Historical number https://community.qlik.com/t5/QlikView/Historical-number/m-p/744000#M472806 <HTML><HEAD></HEAD><BODY><P>How can I calculate the historical number of stocks based on what's in store today and previous inventory changes .</P><P>Is it possible?</P></BODY></HTML> Tue, 16 Dec 2014 09:42:06 GMT https://community.qlik.com/t5/QlikView/Historical-number/m-p/744000#M472806 johanlind 2014-12-16T09:42:06Z Re: Historical number https://community.qlik.com/t5/QlikView/Historical-number/m-p/744001#M472807 <HTML><HEAD></HEAD><BODY><P>Can you post sample input and expected output</P></BODY></HTML> Tue, 16 Dec 2014 09:45:02 GMT https://community.qlik.com/t5/QlikView/Historical-number/m-p/744001#M472807 anbu1984 2014-12-16T09:45:02Z Re: Historical number https://community.qlik.com/t5/QlikView/Historical-number/m-p/744002#M472808 <HTML><HEAD></HEAD><BODY><P>If the variation and changes are specific or uniform ...yes you can</P></BODY></HTML> Tue, 16 Dec 2014 09:47:35 GMT https://community.qlik.com/t5/QlikView/Historical-number/m-p/744002#M472808 saumyashah90 2014-12-16T09:47:35Z Re: Historical number https://community.qlik.com/t5/QlikView/Historical-number/m-p/744003#M472809 <HTML><HEAD></HEAD><BODY><P>I know how much is in stock now , for example, 50000 pcs . Last week , it fell by 5,000 pieces and the week before that , it increased by 10,000 pcs .</P></BODY></HTML> Tue, 16 Dec 2014 10:13:58 GMT https://community.qlik.com/t5/QlikView/Historical-number/m-p/744003#M472809 johanlind 2014-12-16T10:13:58Z Re: Historical number https://community.qlik.com/t5/QlikView/Historical-number/m-p/744004#M472810 <HTML><HEAD></HEAD><BODY><P>If you had data as these:</P><P>week increase&nbsp; </P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50000</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -10000</P><P></P><P>you could make a table with "week" as dimension and "increase" as expression with the option "Full Accumulation".</P><P>Pay attention on the positivity/negativity of "increase".</P></BODY></HTML> Tue, 23 Dec 2014 19:29:05 GMT https://community.qlik.com/t5/QlikView/Historical-number/m-p/744004#M472810 Anonymous 2014-12-23T19:29:05Z