Nprinting 17, how to exclude a string in a filter

[sylvain_piccarreta]

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

[Chanty4u]

try here

How to Create Static and Dynamic Filters Based on Fields

[dwforest]

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

[sylvain_piccarreta]

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]

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.

[Lech_Miszkiewicz]

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

[sylvain_piccarreta]

thanks

[Ruggero_Piccoli]

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.