Nprinting Pivot Table Automatic Filter on multiple Label and Values

SanjayShukla — Fri, 15 Nov 2024 21:53:13 GMT

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

Re: Nprinting Pivot Table Automatic Filter on multiple Label and Values

Lech_Miszkiewicz — Wed, 04 Jan 2023 00:08:12 GMT

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

topic Nprinting Pivot Table Automatic Filter on multiple Label and Values in Qlik NPrinting

Nprinting Pivot Table Automatic Filter on multiple Label and Values

Re: Nprinting Pivot Table Automatic Filter on multiple Label and Values