Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am attempting to use the new Sheet Trigger functionality in the April 2020 release.
In the data load, I am defining the following fields:
LET vStartDate = Num(makedate(2017,10,1))
Date($(vStartDate) + RangeSum(Peek('RowNum'), 1) - 1) AS Date
Date(MonthStart(Date),'YY-MMM') as CYMo
So I set up a sheet trigger using "Select values in a field" option and field CYMo and entered the following formula in the value box:
=Date(MonthStart(Today(0),'YY-MMM'))
I also tried
=(Date(MonthStart(Today(0),'YY-MMM')))
Neither one worked.
Oddly enough, it works when I choose Toggle Field Selection instead of "Select values in field". I have confirmed the "Select values in field" works with other field types and manual entry of the value(s).
Lots of trial and error and solved this.
Had to match the numeric date value for it to work:
=$(=NUM(Monthstart(Today(0))))
This should be in the Qlik documentation for this feature when matching dates in sheet triggers.
Lots of trial and error and solved this.
Had to match the numeric date value for it to work:
=$(=NUM(Monthstart(Today(0))))
This should be in the Qlik documentation for this feature when matching dates in sheet triggers.