topic Re: Store Stock calculations in QlikView

Store Stock calculations

Thu, 02 Aug 2012 09:52:06 GMT

Hello,

I have a total number of items bought in january 2011 as 'Stock'. If I have the number of sold items each day, is it possible to calculate the remaining 'Stoc' month by month?

For example: in January 2011 I have the number in 'Stock', in February I should have 'Stock' = 'Stock'(initial) - sum(Sales) from January, in March I should have 'Stock' = 'Stock'(initial) - sum(Sales) from Jan and Feb, etc.

If I manage to do the calculation for the 'Stock' each month, can I restock from time to time, adding a number to the 'Stock' of the specific month?

Thank you in advance for your help,

Bogdan

Re: Store Stock calculations

Anonymous — Thu, 02 Aug 2012 10:53:21 GMT

Hi,

Based on your requirement I have tried to get a work around..

Find attached qvw.

Hope it helps.

Re: Store Stock calculations

Thu, 02 Aug 2012 11:01:35 GMT

Hello Rathodniky,

Thank you for your response. I do not have the license on this computer, so I am forced to use the Personal Edition. Could you be able to paste it here directly?

Thanks,

Bogdan

Re: Store Stock calculations

Anonymous — Thu, 02 Aug 2012 11:07:44 GMT

Hi,

Load script insert this:

LOAD * Inline [

Months, Stock, Sold

Jan, 100, 80

Feb, 200, 120

Mar, 300, 240

Apr, 400, 420

May, 500, 490

Jun, 600, 530

Jul, 700, 690

Aug, 800, 780

Sep, 900, 950

Oct, 1000, 1000

Nov, 1100, 1005

Dec, 1200, 1230

];

Use a Straight table with dimension - Months

Expression:

Label: Stock - Exp: =Stock

Label: Opening Stock - Exp: =(Above(`Remaining`)+Stock)

Label: Sold - Exp: =Sold

Label: Remaining - Exp: =`Stock`-`Sold`

Label: In Stock - Exp: =`Opening Stock`-`Sold`

Sort - Month - Load order - Original.