topic Re: Purchase/Consumption Calculation expression.Monthwise in QlikView

Purchase/Consumption Calculation expression.Monthwise

rohitians — Mon, 10 Jun 2013 08:10:16 GMT

Hello,

I have an existing report where in we are displaying purchase and consumtion location wise,

but now we want the report to be displayed month wise i.e the month dimension is to be added,

but as i add the month dimension the opening and closing inventory values is not correct,,,,

I am attaching that report in another qv file please help where in i need to make changes so that correct inventory is displayed..

Thanks and Regards,

Rohit Yadav

sujeetsingh — Mon, 10 Jun 2013 08:19:44 GMT

Rohit ,

First of all it seems there is some issue in sample given by you .

Please post a correct sample,

rohitians — Mon, 10 Jun 2013 09:09:20 GMT

Hello,

For opening inventory the code is..

(Sum({$<FinancialYear=,MonthName=,Quarter=,PostingDate ={"<$(=(Min(PostingDate)))"}>} Cost_Amt_Actual)+

Sum({$<FinancialYear=,MonthName=,Quarter=,PostingDate ={"<$(=(Min(PostingDate)))"}>} Cost_Amt_Expected))/100000

for closing inventory i have code as

(Sum({$<FinancialYear=,MonthName=,Quarter=,PostingDate ={"<=$(=(Max(PostingDate)))"}>} Cost_Amt_Actual)+

Sum({$<FinancialYear=,MonthName=,Quarter=,PostingDate ={"<=$(=(Max(PostingDate)))"}>} Cost_Amt_Expected))/100000

now when i introduce month as dimension it does not displays values correct i need to make changes to this code but not able to figure it out ....

Thanks and Regards,

Rohit

sujeetsingh — Mon, 10 Jun 2013 09:23:09 GMT

Its seems you are using Month name in set analysis for exclusion.