Multiple Filters not working NPrinting 17

[Siva_Sankar]

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

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.

[Arthur_Fong]

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.

[Siva_Sankar]

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

[Arthur_Fong · Accepted solution]

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.

[Siva_Sankar]

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

[Arthur_Fong]

Yes, key combination will work also.