topic Issue in NPrinting Report Generation in Qlik NPrinting

Issue in NPrinting Report Generation

sindu_bharathi — Thu, 28 Jan 2016 07:21:44 GMT

Hi All,

I have an issue in NPrinting report generation when there is no data available for the applied filters

Requirement: Individual excel reports needs to be generated for the users for their data( the application has Section access). So,for the user A he needs to see the data that is associated to him alone.

So the Filter on the Field User has been added as Recipient filter. This is working fine when the User say has data in the application.

Issue:

The problem arises when there is nodata associated wih the user, Nprinting generates reports with all the values instaed of displaying N/A in Table columns.

Is there a way, in case if a user doesn't have values then the report generated should have N/A as that is available in Qlikview instead of generating the report for all the values.

Thanks,

Sindu

Re: Issue in NPrinting Report Generation

Daniel_Jenkins — Thu, 28 Jan 2016 08:11:26 GMT

Hi Sindu,

Take a look at the Verify filter parameter in these articles:

Filter Syntax, Parameters, and Options for Importing Recipients

How to Create Static and Dynamic Filters Based on Fields

HTH - Daniel.

Re: Issue in NPrinting Report Generation

sindu_bharathi — Thu, 28 Jan 2016 10:06:13 GMT

Hi Daniel,

Thanks for the suggestion.

The Verify filter parameter will not generate report if the filter field does not have any associated value.

But i need to generate the report with N/A as the column values if the filter don't have any value.

Is there a way to achieve this?

Thanks,

Sindu

Re: Issue in NPrinting Report Generation

Daniel_Jenkins — Thu, 28 Jan 2016 22:57:53 GMT

Hi Sindu,

Could you post a simple sample QVW (perhaps 3 section access users) that shows N/A when there is no data for a particular user? Also mockup Excel files showing what final reports you expect. That will give us something to work with.

- Daniel.