-
Re: Nprinting Cycling Reports
Thomas Cullinane May 27, 2015 11:19 AM (in response to Sarah Robertson)is there set analysis in your charts that show all Managers whatever the selection?
-
Re: Nprinting Cycling Reports
Sarah Robertson May 27, 2015 11:21 AM (in response to Thomas Cullinane)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
Richard Bartley Sep 21, 2015 7:25 AM (in response to Sarah Robertson)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
Richard Bartley Sep 21, 2015 8:00 AM (in response to Richard Bartley)In fact, I just added a table and that showed all values too.
-
Re: Nprinting Cycling Reports
Frank Savino Sep 21, 2015 10:56 AM (in response to Richard Bartley)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 16 Training & Installation/Upgrade Information
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
Richard Bartley Sep 21, 2015 11:26 AM (in response to Frank Savino )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
Richard Bartley Sep 21, 2015 11:27 AM (in response to Richard Bartley)p.s. there are no hierarchies
-
Re: Nprinting Cycling Reports
Frank Savino Sep 21, 2015 12:15 PM (in response to Richard Bartley)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.
-
Re: Nprinting Cycling Reports
Richard Bartley Sep 22, 2015 7:35 AM (in response to Frank Savino )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
Adam Krepistman Sep 22, 2015 9:20 AM (in response to Richard Bartley)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
Richard Bartley Sep 22, 2015 11:06 AM (in response to Adam Krepistman)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.
-
qlik_MSCode.qvw 396.5 K
-
Re: Nprinting Cycling Reports
Daniel Jenkins Sep 22, 2015 6:10 PM (in response to Richard Bartley)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
Richard Bartley Sep 23, 2015 4:10 AM (in response to Daniel Jenkins )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.
-
-
-
-
-
-
-
-
-
-
-
-