topic Re: NPrinting Dynamic Filter with Multiple Selections in Qlik NPrinting

NPrinting Dynamic Filter with Multiple Selections

Kostas_Lag — Wed, 04 Jan 2017 18:24:57 GMT

Hello everyone,

I am trying to create an NPrinting filter which will select multiple selections.

As far as I know this is possible only with Advanced search according to this.

I only manage to kind of make it work with something like this:

Of course in QlikView, you can manually get the same results also with other syntaxes like typing "Austria"|"Norway" but they don't seem to work with NPrinting.

First, do you know if there is a better way to use Advanced Search in NPrinting?

And second, can I make this filter somehow dynamic using an expression or by using a variable in order to control the Country filter?

Thanks in advance!

Re: NPrinting Dynamic Filter with Multiple Selections

lironbaram — Wed, 04 Jan 2017 18:59:13 GMT

if you want to select 2 values, you can just select 2 values you don't need advanced filter

why do you want to use variable in the filter

Re: NPrinting Dynamic Filter with Multiple Selections

Kostas_Lag — Wed, 04 Jan 2017 19:10:27 GMT

Hi Liron,

The only reason I am trying to use advanced search in the filter is to eventually make it dynamic.

So depending on other selections in the qvw, I want the Country field to be filtered with different countries, not just 2, it might be more.

This is just a test I did to see if it works with multiple specific selections.

Re: NPrinting Dynamic Filter with Multiple Selections

Daniel_Jenkins — Wed, 04 Jan 2017 23:45:43 GMT

Hi Konstantinos,

If you store selections in variables - perhaps using some creative parsing and the getcurrentselections() function, you can use those variables in your Advanced Search field filter. Example using dates: filter in Nprinting

HTH - Daniel.

Re: NPrinting Dynamic Filter with Multiple Selections

Kostas_Lag — Thu, 05 Jan 2017 17:50:39 GMT

Hi Daniel,

Thanks a lot for your input! It helped a lot.

Just fyi, I managed to make it work with something like this in the NPrinting filter:

=match(Country,$(vNP.CountriesFilter))

where vNP.CountriesFilter: =Concat(DISTINCT chr(39)&CountryToLoad&chr(39),',')

In this way, I can select multiple values of the Country field based on another field without being even connected.

Best regards,

Kostas

Re: NPrinting Dynamic Filter with Multiple Selections

danielgargiulo — Fri, 17 May 2019 09:47:21 GMT

Hi, I am wondering if you know if this approach works with Qlik Sense (April 2019) and Qlik Nprinting (April 2019)? Essentially i would like to pass values from the Users Qlik Session to be used in Nprinting. I am aware of the OnDemand Capabilities but have a slightly unique use case.

thanks

dan

Re: NPrinting Dynamic Filter with Multiple Selections

Tavo — Thu, 21 May 2020 22:38:33 GMT

Yes, I just confirmed this approach does work in later versions of NPrinting & Sense. The key is the equal (=) sign in the variable definition.