Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
IMPORTANT: PLEASE READ - Labels will be required in the NPrinting forum starting on Friday September 26, 2019: Click here for details and instructions.
Partner
Partner

NPrinting Dynamic Filter with Multiple Selections

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:

NP_Filter.png

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!

1 Solution

Accepted Solutions
Partner
Partner

Re: NPrinting Dynamic Filter with Multiple Selections

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

5 Replies
Partner
Partner

Re: NPrinting Dynamic Filter with Multiple Selections

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

Partner
Partner

Re: NPrinting Dynamic Filter with Multiple Selections

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.

Support
Support

Re: NPrinting Dynamic Filter with Multiple Selections

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.

Partner
Partner

Re: NPrinting Dynamic Filter with Multiple Selections

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

Partner
Partner

Re: NPrinting Dynamic Filter with Multiple Selections

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