Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
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

Labels (1)
0 Replies