topic Nprinting Optimization in Qlik NPrinting

Nprinting Optimization

elie_issa — Wed, 05 Apr 2017 13:21:47 GMT

Hi Guys,

I have the below Nprinting Log about my nprinting schedule job that has around 600 excel reports(filter) to generate.

As you can see in the screen below that every single report is taking around 1 minute to be produced.(highlighted in yellow)

I was running the same schedule from several months and the Report was produced in around 25 seconds.

What should i change from my side to make the Report Producing faster.

Re: Nprinting Optimization

woutermak — Wed, 05 Apr 2017 14:14:18 GMT

I think that the amount of data in your Qlik app is also larger then it was a few months ago. More data will slowdown the speed of creating your reports. You can speed up your reports if you can work with aggregated data instead of all details. For example: Aggregate your data by week

Re: Nprinting Optimization

elie_issa — Wed, 05 Apr 2017 15:46:14 GMT

Thanks for your reply but the size of the files is still the same about 450 KB.

Our report is taking specific dates and specific criteria so the data is not accumulating from month to month.

Re: Nprinting Optimization

woutermak — Wed, 05 Apr 2017 16:50:49 GMT

‌hi,

more important is the amount of data in Qlik. Not your final document. Nprinting must filter throug all the data.

Besides Qlik are there many other things. How busy is your Qlik server and your nprinting server.

You can creatie a Qlik document with only the data and objects for nprinting. This will speed up your process.

Re: Nprinting Optimization

Anonymous — Mon, 23 Apr 2018 14:21:33 GMT

HI Elie

I had similar issues. There are a few things to check.

1. Data - This is before the App showed 1 month of data now it shows 12, or before it was aggregated now its showing individual rows

2. Increase of Sheets - Maybe before you only were populating 4 Sheets now there's 8 sheets

3. Increase of data on each sheet - Maybe before you had 1 chart now you have 3 charts in a Excel sheet

4. Aggr done in Excel - This is where you are doing a resource heavy Template in Excel (i.e sums etc)

5. Bandwidth - If you find everything else to go okay remember these need to be emailed so if your bandwidth decreases this will slow the distribution

The above affected me when i was developing so i thought i would share.