Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
sylvain_piccarreta
New Contributor III

Nprinting 17, how to exclude a string in a filter

 

Hello,

 

On Nprinting 17, how to exclude a string in a filter?

 

For example, I have a list of 50 products and I would like to remove the product 'ABC'

 

Thank you in advance for your help,

 

Sylvain

 

9 Replies
Highlighted
Chanty4u
Esteemed Contributor III

Re: Nprinting 17, how to exclude a string in a filter

Highlighted
dwforest
Valued Contributor II

Re: Nprinting 17, how to exclude a string in a filter

NPrinting does not have an exclude only include.

Workaround is to create a variable in the application to flag records with a 1 or 0 and filter to that.

Highlighted

Re: Nprinting 17, how to exclude a string in a filter

Instead of variable i would create dedicated dimension/flag in load script excluding not wanted values ...

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Highlighted
sylvain_piccarreta
New Contributor III

Re: Nprinting 17, how to exclude a string in a filter

thanks for your help.

And if I want to filter with product A* (Abricot, Ananas, ...) Have I to choose One by One or could I use A* ?

Because, I try to put value egals A* or value évaluate A* but it doesn't match.

thanks again

Highlighted
dwforest
Valued Contributor II

Re: Nprinting 17, how to exclude a string in a filter

yes, unfortunately, discrete values only.

This is another place adding a variable in your app is a good workaround.

Highlighted

Re: Nprinting 17, how to exclude a string in a filter

Hi Sylvain,

have you read documentation?

https://help.qlik.com/

https://help.qlik.com/en-US/nprinting/June2018/Content/ReportsDevelopment/Static-dynamic-filters.htm

you cannot use wildcard. all rules are described there. one of them says:

Static filters let you select a list of values from QlikView or Qlik Sense fields. You must manually edit the filter to change values.

Dynamic filters use QlikView or Qlik Sense formulas. Formulas must use QlikView or Qlik Sense rules and syntax, and return a single value. Formulas are evaluated, and the results are used to filter data. You do not have to modify dynamic filters to gain new values.

cheers

Lech

---------------------------------------------


When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Highlighted

Re: Nprinting 17, how to exclude a string in a filter

you can pick values one by one or create dimension in model picking first letter and filter on this new dimension.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Highlighted
sylvain_piccarreta
New Contributor III

Re: Nprinting 17, how to exclude a string in a filter

thanks

Highlighted
Employee
Employee

Re: Nprinting 17, how to exclude a string in a filter

Hi,

If you need to exclude few values of a long list a workaround could be to use import users from and Excel file to create the filter with the ling list of values you need to keep instead of manually insert them.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.