Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Stock Inventory Ageing

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_BUSL_DTSL_ITEM_CODESL_RCVD_ISSDAgeing
10010/3/20111I2-3 Year
10010/3/20111R2-3 Year
3012/27/20111I2-3 Year
7012/27/20111I2-3 Year
10012/27/20111R2-3 Year
1004/30/20121R2-3 Year
1005/12/20121I2-3 Year
1006/19/20121I2-3 Year
2006/19/20121R2-3 Year
2003/8/20131R1-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

Bucket1-2 Years2-3 Year
Code
1300100

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.

5 Replies
kimrormark
Creator
Creator

Try:

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

Not applicable
Author

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

PrashantSangle

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

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable
Author

Hi max Its too not working

kimrormark
Creator
Creator

Vini, this should work (see attached app):

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