Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

About NPrint parameter

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.

1 Solution

Accepted Solutions
Daniel_Jenkins
Specialist III
Specialist III

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.

View solution in original post

3 Replies
Daniel_Jenkins
Specialist III
Specialist III

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.

Not applicable
Author

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
Specialist III
Specialist III

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.