how to create the filters for excel report results in the Nprinting?

[srinivas1921]

Hi,

I created a excel report to subscription with email attachment using NPrinting. In my excel report ,I want to see the current year, and current month data only.in the qvw there are two fields like booking year and booking month.how do we create filter for current year and month  using this fields in Nprinting.I written like booking year(now()) and booking month(now()).but my expression doesn't give the filter data in the Nprinting.

Kindly provide the expression to create filters for the above scenario.

Thank for your great support....

[Daniel_Jenkins · Accepted solution]

Hi Srinivas,

You can filter for multiple fields, variables and bookmarks in a single NPrinting filter. This one filters on two fields - Booking Year and Booking Month.

HTH - Daniel.

[prma7799]

please check below

How to Create Static and Dynamic Filters Based on Fields

Creating NPrinting Filters Based on Existing QlikView Bookmarks

How to Use QlikView Advanced Search with NPrinting Filters

How to Use QlikView Advanced Search with NPrint... | Qlik Community

[jagan]

HI,

Check this link

How to Use QlikView Advanced Search with NPrinting Filters

Regards,

Jagan.