1) QlikView 12.x is not supported by any version/SR of NPrinting 16 so I would address that first. Check this document: Requirements for QlikView NPrinting 16.x.x.x versions only
2) You cannot use Pivot Tables as the source for PowerPoint native charts in NPrinting. You will need to create a straight table with the required structure in QlikView. When you add a pivot table to your NPrinting report as a table, you will not have access to the individual fields so you cannot build the chart source from that.
HTH - Daniel.
thank you for your quick response! We actually didn't know that QV12 is not supported by NP16, however, we have not noticed any negative impact despite the missing pivot feature yet.
Do you have any idea how we could solve this issue? If we work with straight tables, we end up with the same data mess as shown in my first post above (city name several times and not only once combining all values).
Also, does it make any sense to downgrade our nprinting version for any reason or upgrade nprinting to V17?
were you able to solve this problem?
I was trying to use the dual axis functionality but without luck.
I was able to get the correct data input (from straight table), which can create such chart.
Name Period Value
Name1 Period1 10
Name2 Period1 10
But when I create it in template and then preview or run the task it does not come out correctly. Somewhere during the export axes are changed and the chart is broken.
the good news first: We were able to solve this problem.
The bad news: It is not possible to do this with a direct export into PowerPoint.
We export our data to Excel using three main functionalities:
1. Tables and then making pivot tables out of them
2. Formula to fill cells with the data - these cells are input cells for graphs.
3. Levels to have tables that can change the amount of coloums we need.
I imagine, this might sound a bit overwhelming for the start, but what I initially did when I had to explore it on my own was to understand these three ways of exporting data to excel.
Once you ran the task in Nprinting and you have a filled excel sheet or even more, we copy paste the graphics from excel to powerpoint and embed these. After programming, the workaround looks like this.
1. Make selections in QlikView
2. Run the task
3. Open the output-Excels (this makes the updating process faster)
4. Open Powerpoint and update the embedded links (you can select automatic updates in powerpoint, which you have to do manually after every new graph you embed!)
This really works well for us. We have an output of currently 150 graphs - all of them coming from two generated excel files.
Time from running the task to updated powerpoint (around 6-8 minutes).