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

Anonymous — Fri, 09 Nov 2018 19:22:20 GMT

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

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

pedrobergo — Wed, 14 Nov 2018 09:49:20 GMT

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

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

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

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