About NPrint parameter

[#1]

Hi All,

I am using NPrinting to email the QV report to the users.

In this QV report, there is one field called YearMonth, I want to pass a dynamic value to it and generate the relevant data.

For exmaple, if today is August, I want to show all the data before August. How to do that?

Thanks.

[Daniel_Jenkins]

Hi Isaac,

You can create and use dynamic filters based on fields. Please see: How to Create Static and Dynamic Filters Based on Fields

If you share a sample QlikView source document and an Excel file showing the result you want, it will be easier for someone here to give you a specific solution.

HTH - Daniel.

[#3]

Hi Daniel,

Many thanks for the rely to this thread.

And I have attached my QV report, what I want to show in the excel report is the pivot table.

And the YearMonth parameter, I just want to choose the month before current month, for this report, it should choose 2015-5-1,2015-6-1,2015-7-1.

How to do that.

[Daniel_Jenkins · Accepted solution]

Hi Isaac,

Thanks for the sample document.

Please see a sample project attached. Expand to folder C:\Temp\ISAAC to preserve the paths used or you will need to change the paths in the NSQ. Since you wanted to use YearMonth, I have added a field to the source.

HTH - Daniel.