Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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