topic Re: could not pass multiple values in Nprinting in Reporting Service & Alerting

could not pass multiple values in Nprinting

paulwalker — Thu, 15 May 2025 12:13:05 GMT

Hi Community,

I have implemented nprinting reports and working fine (All the filter I'm generating from qlikview and Importing the data to Nprinting, my filters are Region level data and users are getting specific data with their region)

This is working fine with single region but when user has multiple Regions getting an error like below.

Can you please have a look experts! @Frank_S

Thanks in Advance!

Re: could not pass multiple values in Nprinting

Ruggero_Piccoli — Thu, 15 May 2025 12:25:03 GMT

Hi,

Qlik NPrinting community is at https://community.qlik.com/t5/Qlik-NPrinting/bd-p/qlik-nprinting-discussions, this is community for cloud reporting.

You created a filter returning an empty dataset. If you apply the same selections on the source QlikView document you will see no data.

Best Regards,

Ruggero

Re: could not pass multiple values in Nprinting

paulwalker — Thu, 15 May 2025 17:29:02 GMT

Thanks for quick response @Ruggero_Piccoli

I can see the data for those selections

Re: could not pass multiple values in Nprinting

Ruggero_Piccoli — Thu, 15 May 2025 13:47:13 GMT

Hi,

In the previous screenshot (Qlik NPrinting Filter) you selected Florida and India not Florida and Unknown. Please give a check.

Best Regards,

Ruggero

Re: could not pass multiple values in Nprinting

paulwalker — Thu, 15 May 2025 13:51:01 GMT

In main post Just I have renamed, my real data is Florida and Unknown only

Re: could not pass multiple values in Nprinting

Ruggero_Piccoli — Thu, 15 May 2025 14:21:52 GMT

Hi,

Can you past also the configuration of the Qlik NPrinting filter that you are applying?

Are you applying only one filter? I mean check if you have report, task, users and object filters and if you have more then one check the resulting dataset. You have an error in the filters used in Qlik NPrinting so you have to check them.

Best Regards,

Ruggero

Re: could not pass multiple values in Nprinting

Frank_S — Thu, 15 May 2025 14:49:28 GMT

I agree with @Ruggero_Piccoli .

The problem lies somewhere in your filters.

First, I noticed there appears to be 2 connections associated with this report. That 'should' fine as long as this is not an on demand report. Ideally, it would simplify reporting by ensuring all data resides in a single application.

(Also there is no way to have linked field associations between multiple apps).

Second, make sure that if this report is executed from a publish task (not on demand) that you do not have same filter used directly as a report filter, for a specific user (user filter), as a task filter, or (chart) object filter. This will cause filter issues and report failures.

There are specific examples here in our help pages for Filter Rules.

Check into the above @paulwalker very carefully as you may find your filter issue therein. (also make sure that you do not have any locked fields or always one selected values in your QV app at all. This to may contribute to the issue you are seeing. If your second connection has any any unsupported items in it as well, those to can contribute to filtering issues.

Unsupported QlikView Document item... - Qlik Community - 1714896

Kind regards...

Re: could not pass multiple values in Nprinting

paulwalker — Thu, 15 May 2025 14:58:52 GMT

Yes, I have two filters i.e Region and Current Date (based on that data is filtering)

One task has two reports and two reports has different filters.

Report1: Region and Report Date

Report2: Region_1 and Closed date

Re: could not pass multiple values in Nprinting

Frank_S — Thu, 15 May 2025 15:28:27 GMT

Check example 4 of the 'rules' I mentioned.

Example 4

Task filter: Country = Italy
User filter: -
Report filter: Country = Germany
Resulting filter: empty

You cannot use the same dimension twice in the filter chain task, user, report (and chart object filter if used) as shown above. It's not abundantly clear how you have things structured from end to end so do recheck all the suggestions made here and above including a check for unsupported items.

Kind regards...

Re: could not pass multiple values in Nprinting

paulwalker — Fri, 16 May 2025 11:00:10 GMT

Thanks for the explanation @Frank_S ,

I'm bit confusing, can you please have a look, these filters are having in Report and User level filter.

these all are generating through Qlikview app (will it cause the filter issue)

Please find the user list

Re: could not pass multiple values in Nprinting

Frank_S — Thu, 15 May 2025 17:19:11 GMT

@paulwalker

Take the filter out of the report itself and it should generate the expected output as long as there are no other conflicts. It would seem that your conflict is from the use of the same dimension in the report filter and user filter.

Or remove the filter from the report and the user and only use task filters.
If each user has there own region filter than take the filter out of the report and the task and just keep the region user filter.

The idea is to prevent the situation mentioned in example 4 of the Filter Rules. mentioned above

Depending on what you are trying to accomplish, you may need to create a second task with different filter usage to achieve your objectives rather than two reports with the same report filter in the same task. A second version of the same report (name with v2 perhaps) and a different report filter 'might' the approach to take to avoid 'empty' set.

Kind regards...