Expression Issue

Fri, 21 Jun 2013 10:58:03 GMT

Dear All,

I am Facing one Issue. I want Year on Year Compariosn using below Expression. But i donot know where i Have to put the Current Year Variable Now i put the condition in above four lines but the output is coming zero.

Can any one tell for this kind of Expression where i have to put the Year Condition.

(

Num((Sum({<FiscalYear={"$(vCurrentYear)"},Month=,Quarter=,Day=,NumTransDate={"<$(vMinDate)"}>} RecievedQty)

+Sum({<FiscalYear={"$(vCurrentYear)"},Month=,Quarter=,Day=,NumTransDate={"<$(vMinDate)"}>} WH_RecievedQty)

+Sum({<FiscalYear={"$(vCurrentYear)"},Month=,Quarter=,Day=,NumTransDate={"<$(vMinDate)"}>} IssuedQty)

+Sum({<FiscalYear={"$(vCurrentYear)"},Month=,Quarter=,Day=,NumTransDate={"<$(vMinDate)"}>} WH_IssuedQty)),'##0.00'))

Num((

sum(RecievedQty)+Sum(WH_RecievedQty)

sum(IssuedQty)+Sum(WH_IssuedQty)

),'##0.00')

/QDenoNum

Thanks,

Regards

Deepak

topic Expression Issue in QlikView

Expression Issue