Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
djbloiss
New Contributor III

NPrinting greater than Last Year

I am trying to filter by [Transaction Date] to show all last years data and this year (and have it rolling, so next year show the previous year and the current year.  The Structure of my data is all the tables have a date key that then link back to our MultiCalendar Table.  The date fields am trying to use are all in the MultiCalendar Table.  Here is what I have tried:

=[Transaction Date]>=($(vMax_SO_Closed_Year)-1)

=[ACT Year]>=($(vMax_SO_Closed_Year)-1)

I tried them both connected to [Transaction Date] and to [ACT Year]

vMax_SO_Closed_Year is a variable that shows the current year.  The report consistently shows all years.  What am I doing wrong?

Tags (1)
2 Replies
Support
Support

Re: NPrinting greater than Last Year

Hi,

What version of NPrinting?

I will assume you are using 17.x or 18.x and Year is a field in your data-model holding numeric values of year. This filter will restrict data to current and previous years only:

HTH - Daniel.

Employee
Employee

Re: NPrinting greater than Last Year

Hi,

Start with Daniel's suggestion. As alternative you can add some calculated fields in the reload script. The formulas you posted cannot be added directly in Qlik NPrinting filters.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.