topic Filtering two fields same hierarchy level in Qlik NPrinting

Filtering two fields same hierarchy level

Buschdoktor — Fri, 13 May 2022 09:52:29 GMT

Hi everyone,

Following problem:
I have to use a filter on two fields in Nprinting. I need to filter a set of product groups and ("OR") some items which are not contained in those product groups.

Whatever I tried: Nprinting always puts in a hierarchy ("AND") when using the two filters (or two fields in one filter), so there are far too few items in the report.

How do I get an OR-connection between the two filters?

Thanks for help

Re: Filtering two fields same hierarchy level

Frank_S — Fri, 13 May 2022 19:45:05 GMT

HI @Buschdoktor

Since I'm not exactly sure what your output requirement is, I will suggest that you try performing an 'or' in the Qlik Sense dasbboard itself. If successful, use that formula in the NPrinting filter>advanced search filter tool.

Hope this gets you closer to your requirement.

Kind regards...

Re: Filtering two fields same hierarchy level

Lech_Miszkiewicz — Sun, 15 May 2022 23:37:33 GMT

maybe this will help: https://nprintingadventures.com/2021/09/23/filters-in-nprinting-how-hard-can-it-be-part-2-or-mode/

Re: Filtering two fields same hierarchy level

Buschdoktor — Mon, 16 May 2022 08:54:21 GMT

Thanks @Lech_Miszkiewicz

I solved the issue by setting a flag.