topic Excel Report in Qlik NPrinting

Excel Report

manojkulkarni — Wed, 09 Mar 2016 10:32:53 GMT

Hi Team,

I have one requirement in Npringint design, where in need to create excel report using an template. Template will have 2 sheets, in one sheet we need to fill the data from Qlikview using Nprinting reports & other sheet has some summary details which will be calculated using first sheet data.

How can we do this ? It is possible with Nprinting

Re: Excel Report

Wed, 09 Mar 2016 10:57:54 GMT

Drag and drop individual fields from the chart(s) you want to use onto sheet 1
Build formulas on sheet 2. The formulas need to include the cell with the "field tag" and the cell below the "field tag"

See attached

NB: In my example, I put everything on the same sheet, but you can put the formula on a different sheet from the data.

Re: Excel Report

manojkulkarni — Wed, 09 Mar 2016 18:12:43 GMT

In my case formula's & charts is populated in second sheet using data from first sheet. Using N Printing i need to fill data in respective columns of sheet one.

Can this be possible ?

Re: Excel Report

jonopitchford — Wed, 09 Mar 2016 23:09:36 GMT

Yes, this is possible. Like Aran has said, you can add a table to the first sheet (<sumsales> tag in the example above, but could also be a whole table) and create graphs or formula in the second sheet that references the table in the first sheet (referenced like the example above).

(I'm not sure how much more detail Aran could have provided.)

Re: Excel Report

manojkulkarni — Thu, 10 Mar 2016 05:42:58 GMT

Thanks for your reply. I have tried that solution & it works. But my requirement is something differnet, wherein second sheet is already having charts & formulas which i will be using as template to generate report. I just need to put data in sheet one.

Re: Excel Report

jonopitchford — Thu, 10 Mar 2016 07:36:26 GMT

If you already have the sheet set up the way you want it in an excel workbook, you can open the workbook at the same time as the report editor and select 'copy or move' sheet and you can copy the sheet into the report editor excel file and save it.

Does that answer your question?

thanks

Jonathan

Re: Excel Report

avinashelite — Thu, 10 Mar 2016 07:39:48 GMT

Hi Manoj,

what data you need to put in the sheet 1 ??can you please explain with an example