Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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