Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
try adding an = equal sign in the variable definition
hi, you mean here:vFilter=date(MonthStart(Today(),-1),'YYYY MM')?
yes
vFilter==date(MonthStart(Today(),-1),'YYYY MM')
so I should have two = signs?
no, just the one
Try without the Evaluate option