topic Enabling Default filter in data slicer Pivot table in Nprinting in Qlik Automate

Enabling Default filter in data slicer Pivot table in Nprinting

RaviPuttaswamy5 — Tue, 12 Sep 2023 15:37:27 GMT

Have created Pivot table with data slicer in NPrinting and above is the outcome, could you please suggest how to enable default filter(Selection: Year:2023 & Current Month) in Data slicer when report gets generated and pls suggest how to make the 2nd sheet as landing sheet when we open report.

Re: Enabling Default filter in data slicer Pivot table in Nprinting

RaviPuttaswamy5 — Tue, 12 Sep 2023 16:08:46 GMT

@swuehl Could you pls suggest on this

Re: Enabling Default filter in data slicer Pivot table in Nprinting

RaviPuttaswamy5 — Mon, 25 Sep 2023 07:36:52 GMT

@Vegar & @marcus_sommer & @sunny_talwar -- Could you please suggest on this

Re: Enabling Default filter in data slicer Pivot table in Nprinting

Vegar — Mon, 25 Sep 2023 14:59:55 GMT

As far as I understand there is not possible to define a defauly filter for excel pivot in Nprinting.

However, you could try creating a macro in your Nprinting template that do this when you open the generated excel report.

I don't know the details how to do that in detail, but I guess Google Search, ChatGPT, other Community members or other forums can help you with that.

Re: Enabling Default filter in data slicer Pivot table in Nprinting

RaviPuttaswamy5 — Mon, 25 Sep 2023 15:16:51 GMT

In Qlik Nprinting support Macros ?

Re: Enabling Default filter in data slicer Pivot table in Nprinting

Vegar — Mon, 25 Sep 2023 15:25:46 GMT

No, but excel does. I'm thinking that you could add the macro into your Excel template. So when you open the excel document after you filled it with data from Qlik it will do the finishing touches that you need.