Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
p_verkooijen
Partner - Specialist II
Partner - Specialist II

Publisher & PDF distribution just loop (no reduce)

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 ?

6 Replies
Not applicable

Paul,

Did you find a useful solution for this issue?

p_verkooijen
Partner - Specialist II
Partner - Specialist II
Author

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.

Not applicable

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.

p_verkooijen
Partner - Specialist II
Partner - Specialist II
Author

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

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

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

Not applicable


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