Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
oanalung
Contributor III
Contributor III

QlikView / NPrinting Folder

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? 

5 Replies
vinieme12
Champion III
Champion III

try adding an = equal sign  in the variable definition

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
oanalung
Contributor III
Contributor III
Author

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

vinieme12
Champion III
Champion III

yes

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
oanalung
Contributor III
Contributor III
Author

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

so I should have two = signs? 

vinieme12
Champion III
Champion III

no, just the one

 

Try without the Evaluate option

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.