topic Re: Nprinting Cycling Reports in Qlik NPrinting

Nprinting Cycling Reports

Wed, 27 May 2015 10:32:35 GMT

Hi Guys,

wonder if you might be able to help me.

I'm trying to do n printing report, cycling on the service manager name.

I've created a template report - looks fine, created a task to cycle on that field, selected cycling as an option for that report. I can't seem to get it to work for love nor money

So I'm getting the separate reports by service manager but they are showing all results for all the other service managers. Has anyone had this problem before ?

Thanks appreciate your help

Sarah

Re: Nprinting Cycling Reports

tcullinane — Wed, 27 May 2015 15:19:10 GMT

is there set analysis in your charts that show all Managers whatever the selection?

Re: Nprinting Cycling Reports

Wed, 27 May 2015 15:21:26 GMT

Hi Thomas,

Thanks for replying I posted this this morning and seems to have sorted itself now just before the question came live.

I think the issue was me dragging objects into the template it seemed to be messing it up .

Thanks for your help though

Re: Nprinting Cycling Reports

rbartley — Mon, 21 Sep 2015 11:25:17 GMT

Hi Sarah,

Unfortunately, I am having the same issue. Mutilple files are being generated as expected but the chart I have included in my NPrinting Powerpoint report is displaying all values. I created a formula "=getFieldSelections([MS Code])" and this is showing the expected value in each case, so it seems to be limited to the chart. Any ideas?

Richard

Re: Nprinting Cycling Reports

rbartley — Mon, 21 Sep 2015 11:30:51 GMT

Here is the output from one of the files created by the task

Re: Nprinting Cycling Reports

rbartley — Mon, 21 Sep 2015 12:00:31 GMT

In fact, I just added a table and that showed all values too.

Re: Nprinting Cycling Reports

Frank_S — Mon, 21 Sep 2015 14:52:51 GMT

Richard,

You do not need to use NPrinting cycles to generate this report. Cycling creates a separate document based on a dimension value.

However, if you wish to distribute the reports to specific individuals, you simply need to follow one or both of the following tutorials.

How to Distribute User Specific QlikView Reports to User Folders – Customer Feedback for Vizubi

How to Distribute User Specific QlikView Reports by E-mail – Customer Feedback for Vizubi

Using the page feature in conjunction with recipient distribution described above will allow you to achieve the results you are looking for.

This is also demonstrated in the NPrinting Training videos available at the link below:

NPrinting Training Material

You may have issues with the cycle because there is a filter hierarchy. Any filters applied at higher levels in the project will not be apply to lower levels.

So if you have a cycle filter and a recipient filter, the cycle filter will override the recipient filter.

Filter priority and processing order is also discussed in the training videos.

Re: Nprinting Cycling Reports

rbartley — Mon, 21 Sep 2015 15:26:15 GMT

Hi Frank,

Thanks for responding, but my requirement is not related to a distribution list. I am simply trying to generate one document per MS Code (see example above), where the document should only contain data for that MS code. So far, it is generating a document per MS Code, but the data displayed within that document is showing all MS codes, instead of just the data relating to that MS code, e.g. the IT file should only contain IT data, the UK file only UK data, etc. according to the description of cycling, this is exactly the expected outcome.

Richard

Re: Nprinting Cycling Reports

rbartley — Mon, 21 Sep 2015 15:27:00 GMT

p.s. there are no hierarchies

Re: Nprinting Cycling Reports

Frank_S — Mon, 21 Sep 2015 16:15:42 GMT

There are a number of ways to accomplish your requirement. Recipient Distribution is just one. In this case, could set up each MS code as a 'recipient' and deliver each report to either separate folders or to the same folder. ( in which case you would need to use dynamic naming in NPrinting).

If you want to generate a report containing separate sheets in an excel document or slides in a PPTX, then you can use the page feature to separate each slide or each xlsx sheet. Use recipient distribution to deliver to required folders or folders.

Again, this information is in the training material. If after review the training material which contain the points above in detail, please contact support and we'll provide you assistance from there. I am confident you will find your answers in the training material which support the point above.

NPrinting Training Material

Re: Nprinting Cycling Reports

rbartley — Tue, 22 Sep 2015 11:35:24 GMT

Hi Frank,

Still not working I'm afraid. I have created a report with a page linked to field MS Code, I have a filter at report level to only return MS Code values BG and UK, I have also set up two recipients linked to the task: the first has a filter MS Code {BG}; the second MS Code {UK}. The MS Code related to the page shows correctly, but the graph and table are still not filtered at all. I have not found anything in the training material to help.

Re: Nprinting Cycling Reports

rbartley — Tue, 22 Sep 2015 11:49:51 GMT

Report Template

Report Filter

Recipient BG

Recipient filter

Ricipients associated with task

Re: Nprinting Cycling Reports

rbartley — Tue, 22 Sep 2015 11:51:45 GMT

Output:

Re: Nprinting Cycling Reports

Tue, 22 Sep 2015 13:20:14 GMT

having the code at the page level should work - I jsut did something similar with the NPrinting training environment. Can you provide the qvw and the specific object and I can try to duplicate issue or get it to work. PowerPoint I have found can be fickle and if certain steps are not performed in a certain order, it does not work correctly. In the case where I got it to work, I added the page to the left hand side and then dragged to the PP tempalte itself after the iamge was already on the template

Re: Nprinting Cycling Reports

rbartley — Tue, 22 Sep 2015 15:06:33 GMT

Hi Adam,

Please see the attached qvw. It is a scaled down version of the original QV document, but the issue is the same. The object I am trying to filter on is MS Code. I would like to produce a number of files, each with only one MS Code within.

Thanks.

Re: Nprinting Cycling Reports

Daniel_Jenkins — Tue, 22 Sep 2015 22:10:06 GMT

Hi Richard,

Please remove the Alternate State (AAR Reporting). NPrinting does not support Alternate States & Triggers. If required, you will need to simulate Alternate States using filters in NPrinting.

HTH - Daniel.

Re: Nprinting Cycling Reports

rbartley — Wed, 23 Sep 2015 08:10:51 GMT

Hello Daniel,

Thank you, it worked perfectly after removing the alternate state. I can now generate an individual pptx file per MS Code with the cycling functionality. As suspected, I don't need to use recipient lists and filters, but it might be useful to organise the output into different sub-folders.

Re: Nprinting Cycling Reports

Romanwww — Tue, 21 Mar 2023 10:38:27 GMT

In case you'd still use set analysis, did you try to add multiplication there?

[field]*={'values'} or {$<[field]={'values'}>}

Re: Nprinting Cycling Reports

David_Friend — Tue, 21 Mar 2023 15:41:27 GMT

@Romanwww this thread is 8 years old...looks like the OP is not even a registered Community user anymore...