Problem with Sheet Trigger Selecting Date Type?

SDT — Sat, 16 Nov 2024 18:44:32 GMT

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).

Re: Problem with Sheet Trigger Selecting Date Type?

SDT — Fri, 24 Apr 2020 12:22:40 GMT

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.

topic Problem with Sheet Trigger Selecting Date Type? in App Development

Problem with Sheet Trigger Selecting Date Type?

Re: Problem with Sheet Trigger Selecting Date Type?