topic Re: Nprint Excel Report - Formula Changes when Report is ran in Qlik NPrinting

Nprint Excel Report - Formula Changes when Report is ran

Thu, 21 Apr 2016 19:41:52 GMT

Hi,

I am trying to add up two different qlikview tables that are being brought in my Nprint excel report. Trying to add up each's daily sales.

However, when I create my formlua to be = "tab1" a9+ "tab2" a9 and then run the report, the formula changes to = "tab1" a22+ "tab2" a22 once the data is brought in.

Does anyone know how to write the formula so that it doesn't get effected when I run the report?

My issue in pictures is attached,

Thanks.

Re: Nprint Excel Report - Formula Changes when Report is ran

avinashelite — Fri, 22 Apr 2016 05:46:35 GMT

Do you have any other object placed before a9?? i.e any object placed from a1 to a8 ?? if so then based on that size of that chart the cell values are changing dynamically ...in order to avoid don't place any charts or object from a1 to a8 or make sure the chart cell doesn't exceed this range

Hope this helps you

Re: Nprint Excel Report - Formula Changes when Report is ran

Wed, 22 Feb 2017 09:44:10 GMT

Hi,

When building the Report in the Nprinting report editor (ie where you drag in tables etc to the embedded excel instance), Select the table, and in its properties (bottom let corner of the screen), untick "Expand Range"

Hope this helps

Re: Nprint Excel Report - Formula Changes when Report is ran

Daniel_Jenkins — Wed, 22 Feb 2017 23:43:20 GMT

Hi Christopher,

If you uncheck Expand Range your formula will not be pushed down and could be overwritten depending on the number of rows returned. If you use absolute cell references you will still not get what you want as $C$10 will change to $C$22 in your case. I suggest you use the INDIRECT() function and absolute cell references.

You may also want to hide the referenced cells (D2) containing the absolute reference by changing the font colour to white.

HTH - Daniel.