Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
IMPORTANT: PLEASE READ - Labels will be required in the NPrinting forum starting on Friday September 26, 2019: Click here for details and instructions.
Partner
Partner

define an empty set. : STACK : error in Nprinting

Dear Experts,

 

I have import list of users from excel in Nprinting . users get imported correctly as well as its filter.

but when i applying filters report not generated. when i click on filter fields override  it works fine .

Version . NPrinting : Nov 2017(17.6)

Please see logs and other Product related images  as attached.

Please help me in that.

 

 

Thanks & Regards,

Arvind Patil

1 Solution

Accepted Solutions
Support
Support

Re: define an empty set. : STACK : error in Nprinting

If you use the same filter in two places in the filter evaluation hierarchy, this 'define an empty set' message will appear.

You can view the rules here.

https://help.qlik.com/en-US/nprinting/February2019/Content/NPrinting/ReportsDevelopment/Static-dynam...

from the help page:

Rules

  • Formulas will be evaluated first in order to have static values to manage.
  • Each filter will be analyzed in sequence (task -> user -> report -> object).
  • The values of filter fields at different levels will be intersected.
  • If the intersection gives an empty result, the filter chain will become invalid.

To avoid this empty set, do not use the same dimension twice in the chain above as a filter. Please note that 'cycles' should be considered part of this chain.

Specific Example: If you use 'country = France" as a task filter and 'country = Spain' as a report filter, this will cause the empty set message error.

We are just 'like' you & like to be liked when we provide a helpful answer and or when you press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
5 Replies
Employee
Employee

Re: define an empty set. : STACK : error in Nprinting

Hi,

First of all, please invest few minutes to write an understandable and detailed request. What version on Qlik NPrinting are you using? Did you checked the log files?

This question was discussed many times here in the community, so you could also search and give a check to past conversations.

In any case check the filters. You are doing an invalid selection o you get an empty dataset so the report is not generated.

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.
Highlighted
Partner
Partner

Re: define an empty set. : STACK : error in Nprinting

Dear Ruggero,

-Firstly sorry for incomplete info now i have updated details.
-Also attached log file as well.
-I have checked past discussion but didnt get any helpful for my topic.
-for filters I am sure its correct . I have checked filed value is there.
Thanks & Regards,
Arvind Patil
Partner
Partner

Re: define an empty set. : STACK : error in Nprinting

please Reply @Ruggero_Piccoli 

Support
Support

Re: define an empty set. : STACK : error in Nprinting

If you use the same filter in two places in the filter evaluation hierarchy, this 'define an empty set' message will appear.

You can view the rules here.

https://help.qlik.com/en-US/nprinting/February2019/Content/NPrinting/ReportsDevelopment/Static-dynam...

from the help page:

Rules

  • Formulas will be evaluated first in order to have static values to manage.
  • Each filter will be analyzed in sequence (task -> user -> report -> object).
  • The values of filter fields at different levels will be intersected.
  • If the intersection gives an empty result, the filter chain will become invalid.

To avoid this empty set, do not use the same dimension twice in the chain above as a filter. Please note that 'cycles' should be considered part of this chain.

Specific Example: If you use 'country = France" as a task filter and 'country = Spain' as a report filter, this will cause the empty set message error.

We are just 'like' you & like to be liked when we provide a helpful answer and or when you press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
Employee
Employee

Re: define an empty set. : STACK : error in Nprinting

Hi,

From the logs: "Filters applied to user fd874c96-6d0e-4bcb-8a72-e73d73e139d1 and report afcb3556-8d81-4e2b-aa73-147bb785751d define an empty set. " so you have to check all applied filters (task, user, report and object). 

I also suggest you to update to latest version. This will not solve your issue, but you are using a very old version.

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.