topic Re: Issue with getting prior year to date calculation in App Development

Issue with getting prior year to date calculation

ckchouk123 — Sat, 16 Nov 2024 08:41:52 GMT

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?

Digvijay_Singh — Wed, 14 Feb 2018 17:45:36 GMT

Try this may be -

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

Digvijay_Singh — Wed, 14 Feb 2018 17:47:26 GMT

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