topic Multiple Filters not working NPrinting 17 in QlikView

Multiple Filters not working NPrinting 17

Siva_Sankar — Sat, 16 Nov 2024 00:30:21 GMT

Dear Members,

Recently started working in NPrinting.

Need a help if you have come across this kind of requirement. I create two filters and add to the task for distribution.

The filter is not working.

Eg:

DEPARTMENT, BRANCH

DEP1,

DEP2,

DEP3,BRANCH1

created two filters, one for first two departments and another for department and branch combination.

These two combinational filters not working.

If i add or remove any one filter it works.

P.S. I couldnt able to post this in nprinting community for technical reasons.

Appreciate your help.

Re: Multiple Filters not working NPrinting 17

Arthur_Fong — Thu, 11 Jun 2020 01:54:18 GMT

Try creating a new qvw which only contains all data that NPrinting requires.

In this qvw, apply the filter you did in NPrinting in script level.

Eg:
load
DEPARTMENT,BRANCH
from Fact.qvd
where DEPARTMENT = DEP1 or
DEPARTMENT = DEP2 or
(DEPARTMENT = DEP3 and
BRANCH=BRANCH1);

In NPrinting, create one filter for Department, then add in all the values with 'or' clause.

Re: Multiple Filters not working NPrinting 17

Siva_Sankar — Thu, 11 Jun 2020 03:06:37 GMT

Thanks for the workaround, I will try. Why i have to create a seperate QVW for Nprinting data? How can i have 'OR' filter in Nprinting? Thanks, Siva

Re: Multiple Filters not working NPrinting 17

Arthur_Fong — Thu, 11 Jun 2020 03:18:19 GMT

This is a best practice to avoid memory consumption during reload metadata. Eg: 1GB of original qvw would require 5 mins for reloading metadata.

After filtered in a new layer of qvw for NPrinting to consume, let's say the app is reduced to 600MB, this would require less than 5 mins for reloading metadata.

Sorry my mistake here. Try using the add symbol and dropdown select "Value is". Add all 3 Departments in this filter.

Re: Multiple Filters not working NPrinting 17

Siva_Sankar — Thu, 11 Jun 2020 06:14:58 GMT

Instead of adding different combination of filter condition, if i add a key combination and bring that key combination in the filter will work?

Thanks,

Siva

Re: Multiple Filters not working NPrinting 17

Arthur_Fong — Thu, 11 Jun 2020 06:23:03 GMT

Yes, key combination will work also.