Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

reshma_km
Contributor III

NPrinting 17.3 - Excel Report

Hi,

Is there any limitation on the cell formulas that can be added to an NPrinting report?

4 Replies
sureshqv
Esteemed Contributor III

Re: NPrinting 17.3 - Excel Report

What it means?

you can write all excel formulaes it will work for nprinting,  all excel functionalities will work

reshma_km
Contributor III

Re: NPrinting 17.3 - Excel Report

I need to right almost 3000+ cell formulas. Will that much be supported?

sureshqv
Esteemed Contributor III

Re: NPrinting 17.3 - Excel Report

i think yes it will support . 

if you are writing macros  am not sure  [without macros it will work].

sretepsutah
Contributor

Re: NPrinting 17.3 - Excel Report

Hi,

It is supported and will depend on your server CPU and RAM to calculate all those formulas. That can be very resource consuming.

  1. I would recomend to work with Qlik Charts to calculate the formulas.
  2. If that is also resource consuming, the best way is to generate the values in the script. so the chart is pre-calculated and the excel template is much smaller in size and resources.
Community Browser