define an empty set. : STACK : error in Nprinting

[arvind_patil]

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

[Ruggero_Piccoli]

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

[arvind_patil]

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

[arvind_patil]

please Reply @Ruggero_Piccoli 

[Frank_S · Accepted solution]

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.

[Ruggero_Piccoli]

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