QlikView / NPrinting Folder

[oanalung]

hi, I have a date column that shows only the month  that is build in the following way: 

date(MakeDate(year(date_column),month(date_column)), 'YYYY MM') as [Month]

I want to use this [Month] column in a filter in NPrinting, so the value is compared to a variable and generates the report only for the specific month. 

the variable is: vFilter=date(MonthStart(Today(),-1),'YYYY MM')

If I create a new filter in NPrinting where [Month] - Evaluate Value = $(vFilter) report is failing to generate. 

If I just use [Month] - Evaluate Value = date(MonthStart(Today(),-1),'YYYY MM') is working, but I want to use a variable so everything is only changed from QlikView in the future. 

any idea how to make it work? 

[vinieme12]

try adding an = equal sign  in the variable definition

[oanalung]

hi, you mean here:vFilter=date(MonthStart(Today(),-1),'YYYY MM')?

[vinieme12]

yes

[oanalung]

vFilter==date(MonthStart(Today(),-1),'YYYY MM')

so I should have two = signs? 

[vinieme12]

no, just the one

Try without the Evaluate option