topic Re: define an empty set. : STACK : error in Nprinting in Qlik NPrinting

define an empty set. : STACK : error in Nprinting

arvind_patil — Sat, 16 Nov 2024 04:20:41 GMT

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

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

Ruggero_Piccoli — Tue, 26 Feb 2019 09:11:04 GMT

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

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

arvind_patil — Tue, 26 Feb 2019 11:00:09 GMT

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

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

arvind_patil — Tue, 26 Feb 2019 11:52:39 GMT

please Reply @Ruggero_Piccoli

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

Frank_S — Mon, 15 Apr 2019 22:54:50 GMT

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-dynamic-filters.htm

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.

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

Ruggero_Piccoli — Thu, 28 Feb 2019 11:06:46 GMT

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