Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You do not need pipes, commas parenthesis
It depends what field represents:
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
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.
You do not need pipes, commas parenthesis
It depends what field represents:
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
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.
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
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
@Lech_Miszkiewicz shouldn't the values above be "numeric value is" per your reply above where you stated
It depends what field represents:
I am trying to clarify if it needs to be "numeric value is" or if it will work either way.
We dont know until we check the data type of that field in Qlik Sense, right? You have shown this in this thread at the last screenshot: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Qlik-NPrinting-Filters/m-p/1815609#M32510
But without checking it we never know and often this is mistake causing wrong filter type being applied.
I described this in my blog few years ago: https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/