topic About NPrint parameter in Qlik NPrinting

About NPrint parameter

Tue, 18 Aug 2015 05:57:10 GMT

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.

Re: About NPrint parameter

Daniel_Jenkins — Wed, 19 Aug 2015 07:08:05 GMT

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.

Re: About NPrint parameter

Thu, 20 Aug 2015 02:35:38 GMT

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.

Re: About NPrint parameter

Daniel_Jenkins — Thu, 20 Aug 2015 09:03:35 GMT

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.