topic Re: QlikView / NPrinting Folder in QlikView

QlikView / NPrinting Folder

oanalung — Mon, 16 May 2022 14:26:15 GMT

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?

Re: QlikView / NPrinting Folder

vinieme12 — Tue, 17 May 2022 07:35:27 GMT

try adding an = equal sign in the variable definition

Re: QlikView / NPrinting Folder

oanalung — Tue, 17 May 2022 07:47:31 GMT

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

Re: QlikView / NPrinting Folder

vinieme12 — Tue, 17 May 2022 07:52:10 GMT

yes

Re: QlikView / NPrinting Folder

oanalung — Tue, 17 May 2022 07:53:12 GMT

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

so I should have two = signs?

Re: QlikView / NPrinting Folder

vinieme12 — Tue, 17 May 2022 08:07:49 GMT

no, just the one

Try without the Evaluate option