topic Re: Import from one report into another in Qlik NPrinting

Import from one report into another

danielact — Wed, 11 May 2016 15:36:29 GMT

If I have an Excel report, is there a way to take the results from it, and bring them into a PowerPoint report?

Re: Import from one report into another

avinashelite — Wed, 11 May 2016 16:24:34 GMT

First load the excel data to Qlikview then create the required charts and calculation in Qlikview , then you could use NPrinting tool or Macro export the charts to PPT.

Hope you got the Idea

Re: Import from one report into another

danielact — Wed, 11 May 2016 17:06:41 GMT

Yes, I'm aware of how QlikView works

I can't do it in this case, because the Excel chart is non-standardized, so it won't easily create in QlikView. I can do it in Excel using NPrinting, because I can give certain cells specific formulas. I'd like to then take that resulting report from Excel, and show it in a PowerPoint.

Re: Import from one report into another

Anonymous — Wed, 11 May 2016 17:52:34 GMT

The viewing in PPT part is probably doable. You can bring data into a power point presentation from an external file. If you are talking about using NPrinting as a distribution tool, that is not likely possible. Nprinting is setup to bring data in from QVW files only, not other external sources.

Non-standardized is pretty subjective term. The beauty of Nprinting is that you can place multiple objects out of your QV app to display in your NPrinting template. So, could you create say your master object in QV and then create a second table object that contains only totals or has different column and row formats.

As long as you can achieve your desired output in QV, you can place your objects however you want them in PPT template in Nprinting.

Thinking outside the box here.

HTH