Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ckchouk123
Contributor III
Contributor III

Issue with getting prior year to date calculation

Is there anything wrong with the following Qlik Sense Expression?

Sum({$<[Fiscal Year]={$(=vMaxFY-1)}, [Fiscal Date]={"<=$(vMaxFiscalDatePY)"}>} [Actual Amt])

I have tested the vMaxFY and vMaxFiscalDatePY and they both return the right values:

I am getting all zeros.When I replace the vMaxFiscalDatePY with the actual date, I get values. Any ideas?

Labels (1)
2 Replies
Digvijay_Singh

Try this may be -

Sum({$<[Fiscal Year]={$(=vMaxFY-1)}, [Fiscal Date]={"<=$(=chr(39)&vMaxFiscalDatePY&chr(39))"}>} [Actual Amt])

Digvijay_Singh

Or

Sum({$<[Fiscal Year]={$(=vMaxFY-1)}, [Fiscal Date]={"<=$(=Date($(vMaxFiscalDatePY)))"}>} [Actual Amt])