Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik Sense App - Loop through filter values and Export sheet to PDF

I have a Qlik Sense app that has a handful of charts that respond to a particular filter.

Is there a (programmatic) way to apply filters to the charts, and export the sheet to a PDF.

Ultimately I would like to loop through a list of users, apply a filter for each user to the charts on my sheet, then export each sheet to a PDF.

Is there a way to accomplish this using the Qlik Sense menu items, QMC, via API?

I found a similar topic for Qlik View here: Loop through all filter values then print to PDF but want to know how this would be possible for a Qlik Sense app.

Thank you

1 Reply
pedrobergo
Employee
Employee

Hi Aehsaei,

Since you are using Qlik Sense Enterprise, I think there are three ways:

1) Using APIs:

You must know js and the Qlik Apis and how to authanticate (cause it´s necessary logon into Qlik for each user).

More in https://help.qlik.com/en-US/sense-developer/November2018/Content/Sense_Helpsites/Home-developer.htm

2) Use NPrinting:

The NP it´s a Qlik module that you can import a list of users, fix a list of filters and than apply all that to Qlik automatically. This good tool can export PDF, Excel, Word, Powerpoint, HTML, send then by e-mail, write to disk and others.

More in https://help.qlik.com/en-US/nprinting/September2018/Content/NPrinting/Introduction/Introduction.htm

3) Automate web macros

You can use a tool that automate macros like these:  https://imacros.net/overview/  . There are many tools like that, so google it and test then to choose that seems better to you.

 

Good luck,

 

Pedro