topic Re: NPrinting 17 Cycle Field through Multiple Reports in Qlik NPrinting

NPrinting 17 Cycle Field through Multiple Reports

christygobar — Fri, 03 Jun 2016 15:18:47 GMT

In NPrinting 16, I could cycle through a field (Geography) and create individual Excel reports to a destination folder.

I do not find this functionality in the new v17 - only the ability to create filters.

Using "Page" in the template editor does not get my needs covered, as I need an individual Excel file rather than Excel tabs.

Any assistance?

Thanks!

Re: NPrinting 17 Cycle Field through Multiple Reports

Stephen_Jasionowski — Fri, 03 Jun 2016 16:02:41 GMT

Christy -

The same result can be achieved by creating "users" that represent each value in the Geography field.

Create a user and assign each user a filter on the Geography field representing one of the field values.

Create the desired output folder as a destination and use that in the publish task.

NPrinting will then create a report for each user (a distinct report for each value of Geography) and distribute them to the destination folder.

Re: NPrinting 17 Cycle Field through Multiple Reports

christygobar — Fri, 03 Jun 2016 16:15:49 GMT

A rather tedious result, unfortunately, when I have over 200 geographies and compound that per report. I used to be able to simply cycle on the field.

But I do understand the concept and can test it out on a limited basis.

Ultimately may need to stick with v16 for the foreseeable future.

Re: NPrinting 17 Cycle Field through Multiple Reports

christygobar — Fri, 03 Jun 2016 16:16:09 GMT

Thank you for the quick response!

Re: NPrinting 17 Cycle Field through Multiple Reports

Stephen_Jasionowski — Fri, 03 Jun 2016 16:22:32 GMT

You can set up an Excel file to import the users which shouldn't be difficult to create, even for 200 users. That process is outlined here: http://help.qlik.com/en-US/nprinting/17.0/Content/Recipients&Users/ImportUsersFiltersGroups/Import-Users-Filters.htm

And an sample Excel file is is the examples (Examples ‒ QlikView NPrinting)

You should be able to apply a formula and copy down to get all of the 200+ users and filters established. I'd just make sure to paste values in the file after doing so since I'm not sure how the import would handle data that contains a formula as part of the import.

Re: NPrinting 17 Cycle Field through Multiple Reports

christygobar — Fri, 03 Jun 2016 19:01:35 GMT

Stephen, I found this thread here:

QlikView NPrinting 17 & QlikView Governance Dashboard 2.0 are here

Which basically answers my question - cycling (And dynamic naming, which was also on my list of things I'm missing) appears to be coming at some point in a future release, although not in the one this month. If we believe this to be a function coming sometime this year, I can definitely hold off on doing some of the workarounds above.

Thanks for the assistance!

Re: NPrinting 17 Cycle Field through Multiple Reports

Stephen_Jasionowski — Fri, 03 Jun 2016 20:41:50 GMT

Christy - cycling is a gap feature intended to be closed but at this time I cannot say whether that will be this year or next.

NPrinting will follow the same release cadence as Qlik Sense, meaning 3 major releases in February, June and September with service releases in between. So if it does not make it into the release of 17.2 in September (it is not part of the 17.1 release this month), it will be in a release next year.

Re: NPrinting 17 Cycle Field through Multiple Reports

ssapseid — Wed, 10 Aug 2016 22:07:03 GMT

Just checking if there is anymore progress on the cycle feature being included in NPrinting 17? NPrinting 16 cycles through 1000's of customer dimensions for us. There is no point upgrading to NPrinting 17 unless this feature is supported.

Re: NPrinting 17 Cycle Field through Multiple Reports

Stephen_Jasionowski — Mon, 22 Aug 2016 17:07:42 GMT

The feature will not be implemented this year and I have no timetable at this time on when it may be available next year.

Re: NPrinting 17 Cycle Field through Multiple Reports

ssapseid — Thu, 25 Aug 2016 12:59:14 GMT

Thank you for the information Stephen

Re: NPrinting 17 Cycle Field through Multiple Reports

derekjones — Fri, 17 Mar 2017 17:13:28 GMT

Hi Stephen

I'm just testing 17 and have come across this issue on migrating reports from 16, do you know if there is any update on when this will be available?

Many thanks

Re: NPrinting 17 Cycle Field through Multiple Reports

ssapseid — Sun, 19 Mar 2017 00:07:34 GMT

Hi Derek

This is very frustrating for us. We are in the awkward situation of having to delay Qv11 > QV12 upgrades because NPrinting 16 is not supported by QV12, so we are asking customer who use QV11 and NPrinting 16 to hold off upgrading to QV12.

The reply we got back from Qlik Support is as follows:

Cycle functionality is not yet available but on the road map for NP 17 and preliminary planned to be available in H2 this year. (this can be changed at any time so you should NOT relay on it when making decisions). Please contact your Account Manager for further details There is no direct method to workaround. However, you can use recipient distribution to emulate cycling for now.

Re: NPrinting 17 Cycle Field through Multiple Reports

derekjones — Mon, 20 Mar 2017 08:48:47 GMT

Thanks Steve for the reply.

Not good news then since 11.2 goes out of support end of this year so we're all going to be backed into a corner if they don't sort this out in H2.

Re: NPrinting 17 Cycle Field through Multiple Reports

Mon, 10 Apr 2017 14:48:32 GMT

Hi sjw, Stephen,

Can you give an estimate when this bug will be fixed? (that is without Excel workarounds)

Thanks,

Matthijs

Re: NPrinting 17 Cycle Field through Multiple Reports

Stephen_Jasionowski — Wed, 12 Apr 2017 13:31:37 GMT

I do not have an estimate other than it is on the roadmap for this year. It will not be part of the next feature release in June. We are in the process of analyzing how to implement cycles in NPrinting 17.

Re: NPrinting 17 Cycle Field through Multiple Reports

itec_pao — Wed, 26 Apr 2017 09:16:27 GMT

Stephen is right about the workaround (or actual solution).

Instead of using cycle field, you can use the folder as a recipient and the filter for the Geography field. In the report, you just put up the report. In the task may put the recipients (Geography field) and it will create for each Geography field based on its filter the relating content. I would create the table for recipient, filter, etc. within QlikView, so you can read it into NPrinting.

Once you've done this, you may find it convenient.

Re: NPrinting 17 Cycle Field through Multiple Reports

Lech_Miszkiewicz — Thu, 27 Apr 2017 02:29:44 GMT

It is only workaround and it will work in very simple scenarios only.

Now imagine production environment with dynamic values in field you need to cycle through, also nobody mentioned the fact that this workaround will work only if we want to cycle through the field and produce reports into one common location (else it becomes completly unpractical)

Case Study:

What if reports need to be distributed to different folders/emails so SalesRep 1 cannot see SalesRep 2 reports --> for example: (this is the most common usecase for all clients where cyclic reports are used):

SalesRep 1
- Country Australia (Australia is a recipient filter as this person is reposnsible for this country only)
  - Cycle through cities and produce separate reports for each city (Brisbane, Sydney, Darwin (cities are dynamic - they apear depending on client location))
SalesRep 2
- Country Germany (Germany is a recipient filter)
  - Cycle through cities and produce separate reports for each city (Berlin, Munich, Frankfurt cities are dynamic - they apear depending on client location))

How do you workaround above need?

hopefuly there is a workaround for this - as currently i do not have a fully atomated solution for it.

Note. be aware that No of citites may be greater than 250 - some of my clients have limited no of recipients which we can distribute reports to.

any ideas?

cheers

Lech

Re: NPrinting 17 Cycle Field through Multiple Reports

woutermak — Mon, 01 May 2017 09:33:20 GMT

I have exactly the same case as lech_miszkiewiczdescribed above. Are there any options? Or do we have to wait for cycle option? But I red in the post of Stephen Jasionowski that this option is not in the coming release?

- Is there a time schedule when this option available?

- Is there a list of coming features of the new nprinting release?
I hope you can give me some ideas.
Regards,

Wouter

Re: NPrinting 17 Cycle Field through Multiple Reports

Mon, 01 May 2017 16:10:11 GMT

Hi Stephen

Any further update on what is in the June feature release? Its now May

Re: NPrinting 17 Cycle Field through Multiple Reports

michael_sung — Tue, 02 May 2017 08:35:24 GMT

Hi Stephen,

Can I ask why the cycle function is not in the list of "Known limitations" in the Nprinting 17.3.1 release notes?

The reason I ask this is because I can only upgrade to version 17 once this feature is reinstated, if is was stated in Known limitations list then it would save me the time and effort searching the community forum to check.

Would it be possible to have cycle feature listed as a Known limitation please?