Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Nprinting issue with Excel templates

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

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Hi,

uncheck the Expand range property of the table.

BR,

  Matus

View solution in original post

4 Replies
Highlighted
Creator III
Creator III

Hi,

uncheck the Expand range property of the table.

BR,

  Matus

View solution in original post

Highlighted
Creator III
Creator III

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

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

Highlighted
Not applicable

Yes, it worked. Thank you so much

Highlighted
Specialist III
Specialist III

that might also help full.