nPrinting question: syntax for variable in filter expression?

Thu, 16 Apr 2015 20:06:49 GMT

Don't know if these go here, or not, but here goes:

I want to use the function "FirstWorkDate(date,num of days, excluded dates). with a variable "vHolidays" in the "excluded dates" field.

(vHoliday is simply '1/1/2016','12/25/2016','9/2/2016' etc.) to filter a report to the previous working day, holidays excluded. The function works fine today, but I wanted to add the Holidays in one group, instead of an enumerated list.

First I thought I needed to use $-sign expansion, so in my filter formula, I entered:

=FirstWorkDate(today(0)-1,1,$(vHolidays)), which is accepted just fine, but when I added yesterday's date to the Holiday list to test it, it still gave me data for April 15; not correct.

Then I tried FirstWorkDate(today(0)-1,1,'$(vHolidays)') but this gave me "error in expression" and an empty report, instead of picking April 14.

Finally, I tried "FirstWorkDate(today(0)-1,1,vHoliday), but that again gave me data for April 15, not April 14.

What is the proper way to do this?

thanks,

Kevin

topic nPrinting question: syntax for variable in filter expression? in Qlik NPrinting

nPrinting question: syntax for variable in filter expression?