topic Re: Stock Inventory Ageing in QlikView

Stock Inventory Ageing

Fri, 03 Oct 2014 18:37:07 GMT

Hello Folk

I am having an Adhoc requirement of Client where Client want to see Quantity wise inventory,

For Example we have an following Data

Data:

SL_BAL_QTY_BU	SL_DT	SL_ITEM_CODE	SL_RCVD_ISSD	Ageing
100	10/3/2011	1	I	2-3 Year
100	10/3/2011	1	R	2-3 Year
30	12/27/2011	1	I	2-3 Year
70	12/27/2011	1	I	2-3 Year
100	12/27/2011	1	R	2-3 Year
100	4/30/2012	1	R	2-3 Year
100	5/12/2012	1	I	2-3 Year
100	6/19/2012	1	I	2-3 Year
200	6/19/2012	1	R	2-3 Year
200	3/8/2013	1	R	1-2 Year

in the above given data I is Sold and R is Received on the basis of this Flag Purchase and sold is to be determine.

using the above data Client want to see bucket wise ageing Such As

Bucket	1-2 Years	2-3 Year
Code
1	300	100

I had tried my level best but not able to find any Solution for this,

m also attaching the working and the Excel sheet & QVW file of my working with this post.

Thanks.

Re: Stock Inventory Ageing

Anonymous — Sat, 04 Oct 2014 02:01:52 GMT

Try:

Sum({<SL_RCVD_ISSD = {'R'} >} SL_BAL_QTY_BU) - Sum({<SL_RCVD_ISSD = {'I'} >} SL_BAL_QTY_BU)

Re: Stock Inventory Ageing

Sat, 04 Oct 2014 05:26:42 GMT

Hey Kim,

The above given Expression gives result but it dont give the desired result since, using above expression in 2-3 year bucket it shows 100 and 1-2 year bucket it shows 200,

but client requirement is the old bucket Quantity should also be carried forward in a newer bucket.

Thanx

Re: Stock Inventory Ageing

PrashantSangle — Sat, 04 Oct 2014 05:33:05 GMT

Hi,

Then try with nullifying Bucket field in expression.

try Like,

Sum({<SL_RCVD_ISSD = {'R'},Ageing= >} SL_BAL_QTY_BU) - Sum({<SL_RCVD_ISSD = {'I'} ,Aging=>} SL_BAL_QTY_BU)

Regards

Re: Stock Inventory Ageing

Sun, 05 Oct 2014 09:07:05 GMT

Hi max Its too not working

Re: Re: Stock Inventory Ageing

Anonymous — Sun, 05 Oct 2014 21:25:20 GMT

Vini, this should work (see attached app):

Sum({<Flag = {'R'} >} Quantity) - Sum({<Flag = {'I'} >} Quantity) + after(Sum({<Flag = {'R'} >} Quantity) - Sum({<Flag = {'I'} >} Quantity))