Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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()
Perfect thanks!!
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