Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is my assumption correct that if you have multiple filters on a single object in NPrinting 17, that acts as a "AND" statement? For example, if I have a filter for "Year=2016" and another filter for "State=WI", apply both filters to a report let's say, the data will get filtered down to and just produce a report for records with year 2016 AND state of WI, correct? Thanks.
That's correct subject to you not having set analysis in your objects that ignore them.
You can test by applying the same filters on your app and seeing the results reflected in your object.
This will also test to make sure the objects you are using don't have any set analysis in them that would exclude them from the filters.
That's correct subject to you not having set analysis in your objects that ignore them.
You can test by applying the same filters on your app and seeing the results reflected in your object.
This will also test to make sure the objects you are using don't have any set analysis in them that would exclude them from the filters.
We need to be clearer.
If you are speaking about object filters, you can add only one filter for each QlikView object, as show in the picture.
If you mean that you created two filters and added them to a report like this:
Yes, they works "like an AND", but I would to suggest you to give a check at the filters' rules in the following help site page Static and dynamic filters ‒ Qlik NPrinting. The result is:
Remember to set the drop down menu of the Year value on Numeric value is, otherwise that filter will not be evaluated. Like the following: