Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Expression Issue

=

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

Tags (1)
Community Browser