Individual and Group Report

[robert_mika]

I need to create  4 reports(PowerPoint):

1- for a group of 3 countries.(aggregation)

2-4 - for each of the 3 countries.

Is there a way that I can use the same report? 

I do want to use Pages as this will create one report for each country and the Group.

It would be good if NP allow to set up a cycle when the report is being published not only when is created.

[Lech_Miszkiewicz]

Hi Robert.

Are you really using 17.3 version? If you do - My only suggestion is to upgrade. A LOT has changed since v17.3 in terms of performance, stability and general product functionality. 

From top of my head 17.3 was still a version which i would consider "unusable" due to amount of bugs and issues 🙂

NPrinting 17 and above was rapidly developed throughout last few years. Report Cycle (feature which you are likely to seek in this case) was introduced in version September 2017:

Report cycles
Jira issue ID: PS-1248
Qlik NPrinting September 2017 can generate a separate report file for each
combination of one or more dimension values. Each report will be filtered
according with the combination of values that generates it. For example,
the report file generated for the combination Year = 2017 and Country =
USA will contain only data related to USA in 2017. Each generated report
file will have a unique and customizable filename. For this reason, the
dynamic naming feature will be enabled every time you select cycling.
This was a gap feature from Qlik NPrinting 16.

Workaround - I consider this workaround as clunky - but I am just throwing it there so other people can mabe benefit from it. So workaround would be to create 1 report and 4 tasks, then drive its production using no filters or appriopriate filters for each country. 

So my suggestion would be to upgrade or if you cannot upgrade to use workaround.

thanks

Lech

[robert_mika]

Hi Lech,

Thank you for your answer

Sorry, I should have written version Feb 2020.

Fat fingers....:)

You right the solution is ok.

It will work but:

You need 4 times the amount of work:

Assigning Groups/writing emails, triggers etc.

What if your loop has 10 Countries or 20? The user will get 20 emails...

The simplest solution is to have an option to cycle on the report within Task as we have with rules

(Or on task if that's not possible) or possibility to duplicate reports very quickly- without using export/import options.

I hope this will be developed in the feature.

[Lech_Miszkiewicz]

Hi Robert - If you are on Feb 2020 then yes - you can use Cycle Report when executing  task..

This is available and can be used. I don't understand then why you are not able to use it?

Am I missing something?

[robert_mika]

Hi Lech,

Thank you for swift replay.

Can you point to an option, please?

If I want to have one task and two reports(the same report):

1)Cycle

2) Group

A screenshot would be great.

The other option I just found is to use Replace in the Report section.

Create a new Report, then Replace it with the current report- then add cycle.

[Lech_Miszkiewicz · Accepted solution]

Hi Robert,

My standard approach would be to make sure it is all data driven. In this case I would use only use Cycle report(Group) report would be result of cycle.

Filtering (if necessary done on Country Field or Grouping Dimension - depending on needs)

So first I would create Grouping Dimension - Total for all and then individual countries. That can be done in Qlik script easily. 

GroupingDimension	Country
Total	Australia
Total	USA
Total	GB
Australia	Australia
USA	USA
GB	GB

Then I would use Enable Cycle and would cycle over Grouping Dimension field. That will always create a version for Total and for countries.

Would that be solution for you?