topic Re: Publisher & PDF distribution just loop (no reduce) in QlikView

Publisher & PDF distribution just loop (no reduce)

p_verkooijen — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

We use the Publisher with PDF generation to create Store reports for a client.

Most reports work fine however we got some reports which report over the looped store but also giving info about national and regional numbers.

When using the loop & reduce my data is reduces to store data only, so I can’t use this option. When using the loop through field in the report it creates 1 big PDF with all pages included

Thought of a way to use a lose table in the loop and reduce, with expressions altered to use this as the Store input.

However my document contains info of 314 stores and its size is already 1Gb (Current and Last year data).

The loop and reduce does no clean-up during the loop/reduce but afterwards what would lead to a Temp storage 314Gb of data.

Any ideas ?

Re: Publisher & PDF distribution just loop (no reduce)

Wed, 25 Jun 2014 13:07:11 GMT

Paul,

Did you find a useful solution for this issue?

Re: Publisher & PDF distribution just loop (no reduce)

p_verkooijen — Wed, 25 Jun 2014 14:45:25 GMT

Hi Mehmet,

Contacted Qliktech support / account manager and a QlikTech consulant, however no resolution within Qlikview.

Our useful solution is using a third party solution instead of the Qlikview PDF generation for this report.

Re: Publisher & PDF distribution just loop (no reduce)

Wed, 25 Jun 2014 14:51:24 GMT

I cannot believe that! Can you share the name of the tool? (NPrinting?) And can this tool make exactly what you need?

Thanks in advance.

Re: Publisher & PDF distribution just loop (no reduce)

p_verkooijen — Wed, 25 Jun 2014 15:06:28 GMT

The only solution provided for showing the regional / national numbers was to build a additional table with this data snowflaked from the original data. In such a way that reducing the data would not be a issue.

Because of the temp disk needed this is no option, also the impact needed to create this additional table is far to high.

Nprinting could do the trick, we have developed a simple "tool" that can satisfy our needs regarding distribution of PDF reports.

Take a look at this thread Macro to export AND mail report as PDF

Re: Publisher & PDF distribution just loop (no reduce)

jaimeaguilar — Wed, 25 Jun 2014 15:07:37 GMT

Hi,

It is true that the native pdf reports are not a robust solution. However, before considering using a third party solution (like NPrinting) you may try all possibilities within native reports.

It may be possible to create reports the way you need it, but first I would like to understand your requirement.

So you're saying that you need to generate a report for every store or a report that includes information about all (or some) stores? also it would be useful if you can upload a screenshot of your data model or list the involved dimensions, in order to get a better context of what you need,

regards

Re: Publisher & PDF distribution just loop (no reduce)

Tue, 30 Sep 2014 10:46:38 GMT

Hi Paul,

I did it as your "snowflaked" suggestion.

I posted on my blog; PDF Distribution with no reduce using QlikView Publisher | Mehmet's Personal Blog