NPrinting April 2018 applying filters to wrong connection

[andrewmo]

Hello,

I have submitted a ticket to the support portal for the issues I'm about to describe, but figured I would start a discussion just in case anyone else has experienced the issue.

I have built a collection of reports for an nPrinting app.

This app has 5 different connections.

Those connections have different user filters applied.

I have run into an issue where a report generated from one connection tries to apply filters from a different connection causing the report to fail for those users with an active filter.

Has anyone else encountered this? If so, did you find a solution?

Thank you

[Ruggero_Piccoli]

Hi,

We searched for your support ticket but we did not found it.

In any case:

1 - update your installation to latest version June 2018 and try to replicate the error

2 - post some screenshot (add also the on the support ticket) to let us to understand how you configured filters, connection, how you applied filters etc. There are too few details in your question to understand what is the problem.

3 - check and post the Qlik NPrinting server logs in order to verify if there are errors

4 - check the Task Executions page in order to check if there are errors

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

[andrewmo]

Hi Ruggero,

The case number from the support portal is 01450962.  The case contains all the logs and screenshots.  I do not feel comfortable posting that information here as it contains sensitive information.

Thanks

[Lech_Miszkiewicz]

just hooking myself up to this topic as i am curios what the resolution will be.

Hope you can share once you find a fix

regards

Lech

[Ruggero_Piccoli]

Hi,

I checked and the support guys are working on your ticket.

A the same time note that Qlik NPrinting always applies all the filters not only the ones related to the connections used in the report. Usually this doesn't make any difference and you will have your report filtered. If the filters applied to an unused connection are wrong this will cause an error and the report is not generated.

So try create filters only for the used connection and apply only them and check the results. If it works it means that you made some errors on the filters related to the not used connections so verify them.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

[andrewmo]

Hi Ruggero,

I just double checked that the filters exist in all the source connections and the task still fails. The specific message it is giving me is "ERROR: Cannot apply filter.." along with the filter it is trying to apply.

[Ruggero_Piccoli]

Hi,

There is a problem in how the filters are built. Maybe their result is an empty dataset.

Try to remove all the filters and after apply again one by one to understand which one is creating the problem.

Check also if you are applying selections on the same field with two different filters.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

[andrewmo]

If this is the case, how would you recommend I set up dynamic individualized reports?   Would I need to create a script which updates the user filters daily vs having a known list of possible values?

[Daniel_Jenkins]

Hi Andrew,

For simplicity let us consider these three filters:

Filter1 = Fields: Continent{Europe, Asia}

Filter2 = Fields: Continent{Europe}

Filter3 = Fields: Continent{Asia}

If you apply Filter1 you get a logical OR (Europe OR Asia).

If you apply filters Filter2 & Filter3 in the hierarchy you get a logical AND (Europe AND Asia) which will most probably result in an empty set and the "ERROR: Cannot apply filter.."  message. Take a look at the Filter Rules here: https://help.qlik.com/en-US/nprinting/June2018/Content/ReportsDevelopment/Static-dynamic-filters.htm

Now, if your user needs to get reports filtered for both Europe & Asia all of the time, you would apply only Filter1 as a User level filter for that user and no further action will be necessary. If your user at different times needs to get reports filtered for only Europe or only Asia, you will need to update the User filter (to Filter2 or Filter3) appropriately before running the Publish Task. Either change the filter manually or run an Import Task that uses an appropriately updated Excel file‌ containing the right filter definitions. You will need to manage this Excel file (or files) outside of NPrinting - essentially ensuring that the filter definitions are updated as required. The Import task can be set up to run on a predefined schedule using the Trigger option. You can have several different Import Tasks using different Excel files and run the appropriate one as needed. In addition, different Import Tasks can be set up with different import actions applied. Some planning will be required, but you get the idea :^)

https://help.qlik.com/en-US/nprinting/June2018/Content/DeployingQVNprinting/Import-Users-Filters.htm

HTH - Daniel.

[Ruggero_Piccoli]

Hi,

See Daniel's answer. For a more precise answer useful also for other community members we need more details like the screenshots I asked.

You have one or more filters in one or more connections that you are not using in the report that returns an invalid selection.

As first action remove the filters not related with the used connections and try to run the report. Does this work?

As alternative run the report without filter and add them after one by one so you can understand what is the fiter that generates the error.

Second, give us the details about what are you filtering and how. So maybe we will be able to see what is the wrong filter setting. Or wait the support answer.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.