Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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.
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
Hello, Frank!
Why my designer haven't got this filter in properties?
vasiliy,
I also do not have this option
only available for QlikView for now - are you working with Sense?
Yeah I'm on Qlik Sense
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
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: