Set Analysis help??

rohitians — Thu, 29 May 2014 06:35:39 GMT

Dear all,

I have two codes need help for set analysis,

I have two codes like three months in a row as for now May-14 Apr-14 March-14

For Apr-14 i have wrote

AVG({$<FinancialYear=,MonthName=,FiscalYear = {$(=max(FiscalYear) - $(=if(max(MonthNumber) = 1, 1, 0)))}

,PostingDate={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}PostingDate),-1))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}PostingDate),-1))"},Location_Name_Short={'MFG-GOA I'}>}

Purchaseline_UnitCost)

For May-14 i wrote,

AVG({$<FinancialYear=,MonthName=,Quarter=,FiscalYear={$(=max(FiscalYear))}

,PostingDate={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}PostingDate)))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}PostingDate))"},Location_Name_Short={'MFG-GOA I'}>}

Purchaseline_UnitCost)

Kindly help me to write code for Mar-14 on same lines

Thanks and Regards,

Rohit

Re: Set Analysis help??

rohitians — Thu, 26 Jun 2014 06:46:33 GMT

I got the solution i simply used,

AVG({$<FinancialYear=,MonthName=,FiscalYear = {$(=max(FiscalYear) - $(=if(max(MonthNumber) = 1, 1, 0)))}

,PostingDate={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}PostingDate),-2))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}PostingDate),-2))"},Location_Name_Short={'MFG-GOA I'}>}

Purchaseline_UnitCost)

topic Set Analysis help?? in QlikView

Set Analysis help??

Re: Set Analysis help??