Multiple filters applied to Nprinting excel report

[mgranillo]

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?

[Frank_S]

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.

[Lech_Miszkiewicz · Accepted solution]

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

[Vasiliy_Beshentsev]

Hello, Frank!

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

[mgranillo]

vasiliy,

I also do not have this option

[#6]

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

[mgranillo]

Yeah I'm on Qlik Sense

[mgranillo]

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

[#9]

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.