NPrinting Dynamic Filter with Multiple Selections

[Kostas_Lag]

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!

[lironbaram]

hi

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

[Kostas_Lag]

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.

[Daniel_Jenkins]

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.

[Kostas_Lag · Accepted solution]

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

[danielgargiulo]

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

[Tavo]

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