Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

Nprinting Cycling Reports

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

16 Replies
tcullinane
Contributor II

Re: Nprinting Cycling Reports

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

Not applicable

Re: Nprinting Cycling Reports

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

rbartley
Contributor III

Re: Nprinting Cycling Reports

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

rbartley
Contributor III

Re: Nprinting Cycling Reports

Cycle not working.PNG

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

rbartley
Contributor III

Re: Nprinting Cycling Reports

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

fsv
Contributor III

Re: Nprinting Cycling Reports

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.

rbartley
Contributor III

Re: Nprinting Cycling Reports

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

Highlighted
rbartley
Contributor III

Re: Nprinting Cycling Reports

p.s. there are no hierarchies

fsv
Contributor III

Re: Nprinting Cycling Reports

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

Community Browser