Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

daveatkins
New Contributor II

what is syntax for nprinting filter value in (list)

I want a filter that is simply

value = 191 or value = 192

how do I enter this?

Value is [  ]

what goes in the box? does it need parenthesis? pipes or commas?

1 Solution

Accepted Solutions
Lech_Miszkiewicz
Honored Contributor III

Re: what is syntax for nprinting filter value in (list)

You do not need pipes, commas parenthesis

It depends what field represents:

  • asci text, then Value is 1
  • intiger (number), then Numerical Value is 1
  • dual (like Month can be 1 and Jan, 2 and Feb...etx) then you need to use Numerical Value is 1



If you need 2 values, just add another value below for the same field also see screenshot


here i explained this in details (datatypes)

Re: Nprinting Filters not working on Excel Documents

see screenshots for referenece

1.png2.png3.png

cheers

Lech

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

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 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". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
3 Replies
Lech_Miszkiewicz
Honored Contributor III

Re: what is syntax for nprinting filter value in (list)

You do not need pipes, commas parenthesis

It depends what field represents:

  • asci text, then Value is 1
  • intiger (number), then Numerical Value is 1
  • dual (like Month can be 1 and Jan, 2 and Feb...etx) then you need to use Numerical Value is 1



If you need 2 values, just add another value below for the same field also see screenshot


here i explained this in details (datatypes)

Re: Nprinting Filters not working on Excel Documents

see screenshots for referenece

1.png2.png3.png

cheers

Lech

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

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 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". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
daveatkins
New Contributor II

Re: what is syntax for nprinting filter value in (list)

thanks; that was one of the easier questions to answer about Nprinting! This is one case where the documentation is actually worse than nothing because it suggests that you should express an or condition as a list of values and gives example like that in the text of the tutorial (although no illustration of how to implement it). see Static and dynamic filters ‒ Qlik NPrinting

Lech_Miszkiewicz
Honored Contributor III

Re: what is syntax for nprinting filter value in (list)

no worries David.

It was easy one - although i was not sure if this is actualy what you were asking for as it seemed too easy. Now when you pointed at poor documentation i 100% agree with you.

regards

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
Community Browser