19 Replies Latest reply: Sep 23, 2015 4:10 AM by Richard Bartley

Nprinting Cycling Reports

Sarah Robertson May 27, 2015 6:32 AM

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

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?
Like Show 1 Like (1)

Actions
- 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
  
  Like Show 0 Likes (0)
  
  Actions
  - 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
    
    Like Show 0 Likes (0)
    
    Actions
    - Re: Nprinting Cycling Reports
      
      Richard Bartley Sep 21, 2015 7:30 AM (in response to Richard Bartley)
      
      Here is the output from one of the files created by the task
      
      Like Show 0 Likes (0)
      
      Actions
      - 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.
        
        Like Show 0 Likes (0)
        
        Actions
        
        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.
        
        Like Show 0 Likes (0)
        
        Actions
        
        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
        
        Like Show 0 Likes (0)
        
        Actions
        
        Re: Nprinting Cycling Reports
        
        Richard Bartley Sep 21, 2015 11:27 AM (in response to Richard Bartley)
        
        p.s. there are no hierarchies
        
        Like Show 0 Likes (0)
        
        Actions
        
        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.
        
        NPrinting 16 Training & Installation/Upgrade Information
        
        Like Show 0 Likes (0)
        
        Actions
        
        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.
        
        Like Show 0 Likes (0)
        
        Actions
        
        Re: Nprinting Cycling Reports
        
        Richard Bartley Sep 22, 2015 7:49 AM (in response to Richard Bartley)
        
        Report Template
        
        Report Filter
        
        Recipient BG
        
        Recipient filter
        
        Ricipients associated with task
        
        Like Show 0 Likes (0)
        
        Actions
        
        Re: Nprinting Cycling Reports
        
        Richard Bartley Sep 22, 2015 7:51 AM (in response to Richard Bartley)
        
        Output:
        
        Like Show 0 Likes (0)
        
        Actions
        
        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
        
        Like Show 0 Likes (0)
        
        Actions
        
        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
        
        Like Show 0 Likes (0)
        
        Actions
        
        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.
        
        Like Show 1 Like (1)
        
        Actions
        
        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.
        
        Like Show 0 Likes (0)
        
        Actions

Go to original post