Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
March 9, 10AM EST: Live Chat, Bring your NPrinting Questions! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sylvain_piccarreta
Contributor III
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
Chanty4u
Champion III
Champion III

dwforest
Specialist II
Specialist II

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.

Lech_Miszkiewicz

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.
sylvain_piccarreta
Contributor III
Contributor III

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

dwforest
Specialist II
Specialist II

yes, unfortunately, discrete values only.

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

Lech_Miszkiewicz

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.
Lech_Miszkiewicz

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.
sylvain_piccarreta
Contributor III
Contributor III

thanks

Ruggero_Piccoli
Employee
Employee

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.