Display Filters Being Applied

[jdean1012]

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

[Jacob_Poole]

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.   

[jdean1012]

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()

[Jacob_Poole · Accepted solution]

Try  GetFieldSelections()

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

[jdean1012]

Perfect thanks!!

[Lech_Miszkiewicz]

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