NPrinting greater than Last Year

[djbloiss]

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?

[Daniel_Jenkins]

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.

[Ruggero_Piccoli]

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.