Error in set ad hoc element list, when use code-implemented filters

[Jozefswistak]

Hello.
After using "Set current expressions" to apply a filter in a code of a Measure, I'm trying to set this filter to my own defined value. Here is a code:

sum({<ProductionDate={year(Today()-365}>}[ProductionQuantity])

I'm trying to do this, because I want to have both today and one year ago to aply these values in the same report in NPrinting.

But i return an ifo, that Error in set ad hoc element list.

The question is: is it possible to do like I want (set filter to one year back via code)? Or is it not possible?

[maxgro · Accepted solution]

sum({$<ProductionDate={"$(=AddMonths(Today(),-12))"}>} [ProductionQuantity])

sum({$<ProductionDate={"$(=AddYears(Today(),-1))"}>} [ProductionQuantity])

you can find a handbook on set analysis here

https://community.qlik.com/t5/QlikView-Documents/Set-Analysis-syntaxes-examples/ta-p/1491810