Nprinting Pivot Table Automatic Filter on multiple Label and Values

[SanjayShukla]

Hi Everyone,

I have created Pivot Tables using Excel table columns (Tags)   Creating Excel pivot tables ‒ Qlik NPrinting .

Requirement:
I want whenever my Excel Report Generate it should auto select Filter on multiple Label for few values not all of Pivot Table. e.g.  I want auto select 22 out of 30.

Methods I Tried:
1. We have Tags in Nprinting so not able to select values in Nprinting Designer so selecting All option but not all values are getting Auto select (Creating Excel pivot tables ‒ Qlik NPrinting).

2. Tried Advanced Filter but it didn't workout.(https://trumpexcel.com/excel-advanced-filter/)

3. Can we select multiple values in Label filter for does not equal or contain option(any delimiter to specify Pen, Cap etc. )?

Please help

#Nprinting # Pivot #Filter

[Lech_Miszkiewicz]

I can only think about MACRO xlsm template and macro which would set values in pivot table once you open it on PC. Note that all macro restrictions on users PC have to be taken into considerations when implementing such solution