Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mgranillo
Specialist
Specialist

Multiple filters applied to Nprinting excel report

Is it possible in Nprinting 17.3 to have different filters applied to different sheets?  I need to create an excel report with two sheets.  On one sheet I need it filtered by an indicator flag =1 and on the other sheet I need to filter when the indicator flag = 0.  I think this was an option in earlier versions.  Was this functionality removed? Is this possible?

1 Solution

Accepted Solutions
Lech_Miszkiewicz

Hi

Why dont you use this field as a page - maybe it would be worth to slightly changed value of the falg so your sheets would have more friendly names, but still it would work!

That automaticly will create one report with value filtered to 0 another with value filtered to 1 and create a sheet for aeach of it.

If you have more values in it you can filter whole report then to only 0&1

regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

8 Replies
Frank_S
Support
Support

Mike,

You can still use object filters on images and tables in NP 17.

You can apply the filter to the sheet object as needed.

sheet filters.PNG

We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
Lech_Miszkiewicz

Hi

Why dont you use this field as a page - maybe it would be worth to slightly changed value of the falg so your sheets would have more friendly names, but still it would work!

That automaticly will create one report with value filtered to 0 another with value filtered to 1 and create a sheet for aeach of it.

If you have more values in it you can filter whole report then to only 0&1

regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

Vasiliy_Beshentsev
Creator III
Creator III

Hello, Frank!

Why my designer haven't got this filter in properties?

2017-02-16 15_43_33-Template Editor.png

mgranillo
Specialist
Specialist
Author

vasiliy,

I also do not have this option

Not applicable

only available for QlikView for now - are you working with Sense?

mgranillo
Specialist
Specialist
Author

Yeah I'm on Qlik Sense

mgranillo
Specialist
Specialist
Author

Lech,

I'd rather not change my data but I see that it will work and at this point it's my only option.

Thanks for the suggestion.

Mike

Not applicable

If Flag is a dimension with 2 values (0, 1) only, then use the Page feature:

How to Use the Page Feature in Excel and PowerPoint Report Templates

If Flag is a dimension with many values but you only want 2 sheets (for Flag=0 and Flag=1), then:

  1. Build a filter for Flag =0,1 and apply this to the Report (or User or Task)
  2. Use the Flag dimension in the Page feature.