topic Re: NPrinting Automatic Filters in Qlik NPrinting

NPrinting Automatic Filters

diego_rueda — Sat, 16 Nov 2024 05:12:21 GMT

Hi,

I want to connect NPrinting with a Database. On this database i have users and filters for all apps. Actually im using this database to make section access on qliksense apps and i want to create and assign filters based on this database.

Is possible create automatic filters based on this database and assign that for each user?. For example i have one user that has region filter and i want to create this user, create filter and assign that for one report. Is that Possible?.

Hola,

Quisiera saber si es posible administrar, crear y asignar filtros haciendo uso de una base de datos. Actualmente tengo todo lo relacionado con Section Access en mis aplicaciones de qliksense y quisiera saber si es posible hacer uso de esta base de datos para crear filtros, asignarselos a los usuarios y a los informes de manera automatica. Con lo cual solo sería necesario hacer mantenimiento en la base de datos.

Re: NPrinting Automatic Filters

Lech_Miszkiewicz — Mon, 19 Nov 2018 12:29:00 GMT

Hi,

I suggest you go to https://help.qlik.com and get some basic understanding what NPrinting is and how it works!

NPrinting uses QlikView or Qlik Sense as a source of data + LDAP & Excel as a potential source of user import.

NPrinting cannot be directly connected with DB. You can workaround your requirement by:

pulling your user data from your DB to qlik
creating NPrinting report (Excel Template) which will create a file, which then can be used during recipient import and can create/update or delet recipients
make sure you review on the above mentioned website the exact format of the XLS which needs to have fields and sheet names static and in certain format&order!

cheers

Lech

Re: NPrinting Automatic Filters

diego_rueda — Mon, 19 Nov 2018 16:23:35 GMT

Hi,

Thanks for your answer.

All problem is because I need to send report to 300 users and each one has their own filter per user that is stored in a mysql database. I want to create and asign filters automatically when i'm importing users and allocate filters on filters section.

Using this i can generate and send tis reports without create each one user and filter on diferent row values and fields for one connection. I was reading about use REST API Connector and create this process but this is so complex. I was thinking that maybe is possible using other kind of strategy.

Re: NPrinting Automatic Filters

Lech_Miszkiewicz — Mon, 19 Nov 2018 21:03:12 GMT

this can be done and is described in help document as i said before...It just cannot be done directly from your DB.

https://help.qlik.com/en-US/search/?q=import+users

you are not the first person who needs to send reports to 300 recipients.

regards

Lech