Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
griffinleow
Partner - Contributor III
Partner - Contributor III

Filters applied on empty report generated errors

Hi

I encountered the following behavior in NPrinting designer 17 and I want to check if this is an intended behavior.

My current set up is Qlik Sense connected to NPrinting, where data is loaded into QS dashboards. There will 2 QMC tasks that will reload the metadata and trigger NP publish tasks via API. Filters for the .xlsx reports are applied in NPrinting.

Just last week, there was a day when no data from the source was sent to QS. As such, it is expected to see empty rows in the .xlsx report. However, there was no .xlsx report generated for this particular day. I troubleshooted the issue in NPrinting designer to see if there is anything wrong with the applied filters and the report template. However, when I clicked on 'Preview' in Designer, an error message was generated stating that the error is due to the NP filter.

I suspect that NP filter cannot be applied on an empty report. Is there any way for the .xlsx report to be generated even though there is no row or data?

Thanks

Labels (1)
1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support

Hi,

I think you are experiencing:

  • If the application of a filter results in an impossible selection, a specific error is returned: "Cannot apply filter {0} to current document data. Requested fields with evaluates are: {1}",

from http://help.qlik.com/en-US/nprinting/June2019/Content/NPrinting/ReportsDevelopment/Static-dynamic-fi...

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

6 Replies
Ruggero_Piccoli
Support
Support

Hi,

I think you are experiencing:

  • If the application of a filter results in an impossible selection, a specific error is returned: "Cannot apply filter {0} to current document data. Requested fields with evaluates are: {1}",

from http://help.qlik.com/en-US/nprinting/June2019/Content/NPrinting/ReportsDevelopment/Static-dynamic-fi...

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Frank_S
Support
Support

In addition to Ruggero's comments

You may wish to utilized the following task settings to manage email distribution when report errors are encountered.

https://help.qlik.com/en-US/nprinting/June2019/Content/NPrinting/AdministeringQVNprinting/MonitorKil...

This feature is included with April 2019 NPrinting releases and later versions only. June 2019 is now available and I suggest upgrading to that version to leverage the most recent updates, bug fixes and performance enhancements.

hope this helps...

We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
griffinleow
Partner - Contributor III
Partner - Contributor III
Author

Hi Frank,

Thanks for your reply, it was very helpful to learn of the new feature from April 2019 onwards.

We will try this out if this works for our case.

Regards,

Griffin

griffinleow
Partner - Contributor III
Partner - Contributor III
Author

Hi Ruggero,

Thanks for your reply. 

Now that you mention this, it does seem like the root cause in my case. I would like to clarify further on this. 

  • If the application of a filter results in an impossible selection, a specific error is returned: "Cannot apply filter {0} to current document data. Requested fields with evaluates are: {1}",

This particular report contains a filter on 2 fields applied. Based on the above, it means that if there is no data when filter for the 1st field is applied, it will result in an impossible selection when the filter for the 2nd field is then applied. Is this understanding correct?

In addition, there is another report that is empty but is being generated on a particular day. Similar, this report contains a filter on 2 fields. We checked in QS dashboard and applied the filter on the 1st field (via filter pane), and there was data/rows. The filter for the 2nd field was then applied, and there is no data/rows. Based on this, I am inferring that a filter cannot be applied on an empty dashboard. Is this understanding correct too?

 

Thank you

Ruggero_Piccoli
Support
Support

Hi,

Yes, you understood correctly.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
griffinleow
Partner - Contributor III
Partner - Contributor III
Author

Hi Ruggero,

I clarified about the following behavior previously:

This particular report contains a filter on 2 fields applied. Based on the above, it means that if there is no data when filter for the 1st field is applied, it will result in an impossible selection when the filter for the 2nd field is then applied. Is this understanding correct?

In addition, there is another report that is empty but is being generated on a particular day. Similar, this report contains a filter on 2 fields. We checked in QS dashboard and applied the filter on the 1st field (via filter pane), and there was data/rows. The filter for the 2nd field was then applied, and there is no data/rows. Based on this, I am inferring that a filter cannot be applied on an empty dashboard. Is this understanding correct too?

However, we begin to see a different behavior for the second case. In the dashboard, the first filter ('Evaluate Value is' in NP) applied returns some data. When the second filter ('Value is' in NP) is applied, it returns zero records. However, the report is not generated and throws an error out mentioning something about the filter.

Could you kindly advise what could be the issue here?

Thanks