topic Re: Nprinting issue with Excel templates in Qlik NPrinting

Nprinting issue with Excel templates

Mon, 16 Jan 2017 10:45:56 GMT

Hi everyone,

I'm using Nprinting to distribute Excel reports. and recently I encountered a problem with using pre saved excel formats in Nprinting. I have saved an excel with formulas in several columns(lets say column M to W), and I want Nprinting to dump the data from Qlikview object onto the excel sheets in desired columns(e.g column A to I).

Nprinting, on the other hand, while copying the chart object inserts new rows and this in turn pushes down all the formulas.I have tried inserting Levels first, but that also didn't help.

If you see the attached excel, I want to insert Qlik Object on the Data-Day and Data-Week tabs, and the Day and Week Tabs

respectively would update and perform the calculations in Columns M to W, But since Nprinting inserts new rows, when copying the Object, the formulas are pushed down and the calculation starts from row M11 instead of row M1.

Can anyone please suggest a way to lock the rows in this case or if there is anyother workaround? TIA

Re: Nprinting issue with Excel templates

mkelemen — Mon, 16 Jan 2017 11:15:19 GMT

Hi,

uncheck the Expand range property of the table.

BR,

Matus

Re: Nprinting issue with Excel templates

neha_sri — Mon, 16 Jan 2017 12:39:26 GMT

Use keyword "indirect" in the formula, that will not move your data.

eg: =INDIRECT("A4") where in place of "A4" put the cell address.

Re: Nprinting issue with Excel templates

Mon, 16 Jan 2017 14:26:34 GMT

Yes, it worked. Thank you so much

Re: Nprinting issue with Excel templates

agni_gold — Thu, 19 Jan 2017 05:02:16 GMT

that might also help full.