topic Re: Inventory As on Date - Calculation help in QlikView

Inventory As on Date - Calculation help

Wed, 08 Feb 2012 14:02:06 GMT

Hi All,

I have a requirement from my management asking for a daily inventory of the stock available.

I have attached the file with table structure, expected output and calculation rules for that.

Kindly help me in getting the desired result and it is urgent. Thank you.

Inventory As on Date - Calculation help

avastani — Wed, 08 Feb 2012 14:10:31 GMT

2 ways to do this. in script using the Developer 2 example or in the chart using the ABOVE() function to compute inventory.

ABOVE only works in a straight table. If PIVOT then use LEFT()

Re: Inventory As on Date - Calculation help

Thu, 09 Feb 2012 04:24:28 GMT

Thanks for the sugession amirvas.

However I believe that I might not have given you clear requirement.

Let me clarify you once again as below.

I have a table with daily products entered.

I have attached a new file seperated with Table and Output sheet tabs.

When I look at the inventory on a daily basis, I would like to get the data calculated on a As on Date basis as below.

Eg: For As on Date 1/1/2012 - 4 products

For As on Date 2/1/2012 - 6 products (as 2 products are newly added on 2nd and 2 are already calculated for 1st so we should not included already calculated in previous dates)

For As on Date 3/1/2012 - 8 products (as 2 products are newly added on 3rd and 3 are already calculated on 1st, 1 is calculated on 2nd, so it should not calculated already calculated products previously.)

Like this it should calculate the data till whereever the data is stored into database.

Suppose when I look at the data as on 2/1/2012 then data should be as follows

1/12012 - 4; 2/1/2012 - 6

Hope u understand this and provide the output.

Re: Inventory As on Date - Calculation help

Tue, 11 Dec 2012 17:55:27 GMT

Hi.

I have exactly the same issue. Did you find a solution ?