Applying filter in Nprinting

[hitha1512]

Hi Team,

I need to generate report for previous month data using NPrinting. Tried applying various filter to get previous months data, but failed. 

Since i am new to Nprinting, any help would be appreciated.

[Frank_S · Accepted solution]

You need a dimension in your data model for month.

For example, dimension: 'Month'

• Create and NPrinting filter using 'Month' dimension
• Use the following formula Month(now()) - 1
• (dimensions usage is 'case sensitive' so spell your dimension correctly.
• The filter type needs to be set to 'evaluate'
• Save the filter
• Add the filter to your report, or your task but not to both.

Use the following link which explains more about filters:

• https://help.qlik.com/en-US/nprinting/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.ht...

Kind regards...

[hitha1512]

@Frank_S  thank you 🙂 that worked. 

[Frank_S]

No worries @hitha1512