topic Re: Display Filters Being Applied in Qlik NPrinting

Display Filters Being Applied

jdean1012 — Tue, 08 Nov 2022 15:40:37 GMT

We use NPrinting to distribute pre-filtered PowerPoint decks to leadership. Is there a way to display in the PowerPoint what filters are being applied?

For example, if we have a Sales QlikSense visual that we have embedded in NPrinting, and in the publish task it is filtered to "John", is there a way to create a formula or something in the report that titles the PowerPoint slide "Sales - John"?

THANKS

Re: Display Filters Being Applied

Jacob_Poole — Tue, 08 Nov 2022 15:55:10 GMT

If your template is always going to be filtered for a single user, then the simplest way could be to add a formula in NP to output the value of the filed where "John" is. You can concatenate that with the "Sales - " prefix.

Re: Display Filters Being Applied

jdean1012 — Tue, 08 Nov 2022 15:59:57 GMT

Right...that is what I was asking. What formula would I use? I just found this one and it seems to work fairly well, but it will get weird if I apply any other filters. Any others?

=getCurrentSelections()

Re: Display Filters Being Applied

Jacob_Poole — Tue, 08 Nov 2022 16:02:42 GMT

Try GetFieldSelections()

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/ChartFunctions/FieldFunctions/getfieldselections.htm

Re: Display Filters Being Applied

jdean1012 — Tue, 08 Nov 2022 16:08:26 GMT

Perfect thanks!!

Re: Display Filters Being Applied

Lech_Miszkiewicz — Tue, 08 Nov 2022 23:50:28 GMT

Hi. Just one thing to nete - You may need to verify if values included in selection but excluded due to association to other filters are still visible.

cheers