Well, i do not fully understand the problem.
First of all Pivot Table will not be transfered as data from Qlik Sense to NPrinting. You can export data as a straight table and then use excel based functionality to pivot it.
The second part of your question is confusing (regarding selections on Year & Month). My question is - Does it work in Qlik Sense? Do you get right results in Qlik Sense? If yes - then we can only focus on NPrinting bit which may be little bit tricky, but still achievable..
Could you please screenshot what you have in Qlik Sense, then provide a drawing or mockup of what you are trying to achieve in NPrinting and we will take it from there?
Ok, I was referring that I want to transfer the object as a Table not as an Image.
I have the straight table in Qlik Sense (made after the Pivot Table), imported it and I have 2 sheets in the NPrinting report: Source (straight table) and Pivot Table.
Yes, it works in Qlik Sense and the results are correct.
This would be the Pivot Table in Qlik Sense (I removed the values):
This is the Excel expected output:
I am not sure how does it work using 5 KPI Measures. I was also thinking about importing a template from an Excel file into NPrinting and populating it, but I don't know how I can do the populating part.
I also encountered this issue when verifying the connection to the Qlik Sense app. Maybe this helps in some way:
Also, I encounter this sometimes:
Thanks a lot,
The Windows user who runs the Qlik NPrinting Engine Windows service must be a domain user. There are other requirements to connect to Sense, I would to suggest you to check the page https://help.qlik.com/en-US/nprinting/September2017/Content/DeployingQVNprinting/Installing-qlikview-nprinting-engine.ht…
The results of the Run verification must be all green before proceed.
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.