Inventory Calculation expression.

rohitians — Mon, 15 Apr 2013 06:15:39 GMT

Hello,

SUM(AGGR(if(date(vSelectDate)-max({$<[Inv Flag]={1}>}[Posting Date])>=181 ,

((SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))},[Posting Date] ={"<=$(=MonthEnd(Max([Posting Date])))>=01/04/2012"},[Inv Flag]={0,1,3,5}>}QTY_SIGNED) /* Closing Qty of prev month*/

SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))},[Posting Date] ={"<=$(=MonthEnd(Max([Posting Date])))>=01/04/2012"}>}[Sales Invoice Qty]) /*sales Qty from 1/4/12 till date*/

SUM({$<FinancialYear=,Quarter=,MonthName=,[Posting Date] ={"<=$(=MonthEnd(Max([Posting Date])))>=01/04/2012"}>}[Sales Bonus Qty]) /*sales Bon Qty from 1/4/12 till date*/

SUM({$<FinancialYear=,Quarter=,MonthName=,[Posting Date] ={"<=$(=MonthEnd(Max([Posting Date])))>=01/04/2012"},[Sales Return Type Code]={0}>}[Sales Return Qty]) /*sales Ret Qty from 1/4/12 till date*/

SUM({$<FinancialYear=,Quarter=,MonthName=,[Posting Date] ={"<=$(=MonthEnd(Max([Posting Date])))>=01/04/2012"},[Sales Return Type Code]={0}>}[Sales Return Bonus Qty]) /*sales Ret Bon Qty from 1/4/12 till date*/

)

*avg([Stat Rate Inv]))/100000),[Product Batch Code],[Location Code],[Product Code],[Expiry Date]))

The above is the excisting expression where i get inventory from 1-4-2012 ,

now i am intoducing financial year , suppose i select 2013-2014 it should only show this years inventory rather then from 1-4-2012 where do i change this expression...

Thanks and Regards,

Rohit Yadav

Re: Inventory Calculation expression.

Jason_Michaelides — Mon, 15 Apr 2013 10:08:41 GMT

Wow. I would seriously look at reworking your data model to allow a simpler calculation! Can help with that if you like - please post the data model and some sample data.

Jason

Re: Inventory Calculation expression.

rohitians — Wed, 17 Apr 2013 09:38:13 GMT

hello,

Yes the logic has to be changed i have realised that but i am not allowed to share any info in my company sorry.. thanks for your reply.....If possible would mail u my logic if give ur email id..

Thanks and Regards

Rohit Yadav

topic Re: Inventory Calculation expression. in QlikView

Inventory Calculation expression.

Re: Inventory Calculation expression.

Re: Inventory Calculation expression.