Enabling Default filter in data slicer Pivot table in Nprinting

[RaviPuttaswamy5]

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.

[RaviPuttaswamy5]

@swuehl Could you pls suggest on this

[RaviPuttaswamy5]

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

[Vegar]

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.

[RaviPuttaswamy5]

In Qlik Nprinting support Macros ?

[Vegar]

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.