Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In my team we are using Feb 2021 version for both NP and QS.
I am trying to send an email to a group of users, the users list are dynamically created in a straight table in QS app. What I am trying to achieve here is, extract the email ids from the table and pass it as parameter to NPrinting. From NP, an email need to be generated for each user extracted from the straight table. There are some KPI values in the QS app, I am using HTML embedding to retrieve the KPI values from app and attach it in the email.
I added all the users to a group and that group is added to the NPrinting groups. In the NPrinting connection, I have checked the box which says "Apply Section Access".
The problem I am facing is, while generating reports for 3k users, the task takes nearly 12 hrs to complete. If i uncheck section access, I couldn't retrieve KPI value specific to each user, but the task gets completed faster.
I need to send emails to users extracted from straight table from QS app along with KPI values.
Can anyone share a solution/idea to implement this requirement.
Hi,
This is not an easy task to discuss on community. It is performance issue related to a volume of reports you need to generate.
It means that every element needs to be 100% perfect. So the first thing is to check following:
That would be my starting point.
cheers
Lech
I forgot to mention the most obvious one - Performance of your Qlik Sense server is critical - so make sure that there is nothing slowing it down...
Hi,
Using Section Access resulting in worst performances, so longer generation time, respect than native Qlik NPrinting filters. So I suggest you to move to filters. You have to evaluate if you can add the filters creation in the exported Excel file with the users details.
About performances refer also to https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/DeployingQVNprinting/Performance.htm and note that the generation time depends also on the structure of the template. For example many Levels, in particular if nested, will result in longer generation times because each combination is a different filter that must be applied and wait until related data are exported.
Best Regards,
Ruggero