Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

rglenn0780
Contributor

QlikSense NPrinting Questions

I have a couple questions that would be very helpful to me.

1.) How do I use the page feature in NPrinting twice in the PowerPoint version. What I mean is, I want to sort by product line for some information that I build on a slide but then by product line for other information on another slide. So, slide 1 is the intro slide, slide 2 is the first one I want info for every product line. Slide 3 is different information, but I want it paged out by product line as well.

I am able to get the page function working by different pages such as Product Line and Business Capability but when I try to use the feature for product line twice, it wont do it for all slides....only one or the other. Please help.

In a totally different report...

2.) I want to categorically sort my pages by business capability and corresponding product line. Currently, when I use the page function, I get a full list of business capabilities then a full list of product lines. Is there a way to get the product lines to correspond to their business capability instead of one list before another? Thanks so much.

Thank you all so much...

1 Solution

Accepted Solutions
Employee
Employee

Re: QlikSense NPrinting Questions

1. If you want to use the page feature on multiple slides, you can do that in the properties panel for the page: How to Add Pages Cycled in Multiple Slides

2. If you want to page thru multiple dimensions, you need to have a table that contains both of the dimensions, and then use that object as the page: How to Use Pages to Generate Individual Slides in PowerPoint for Each Combination of Multiple Field ...

Note that these tutorials reference NPrinting 16 and QlikView, but they should still apply to NPrinting 17 and Qlik Sense. Please let me know if these do not resolve your issue.

13 Replies
Employee
Employee

Re: QlikSense NPrinting Questions

1. If you want to use the page feature on multiple slides, you can do that in the properties panel for the page: How to Add Pages Cycled in Multiple Slides

2. If you want to page thru multiple dimensions, you need to have a table that contains both of the dimensions, and then use that object as the page: How to Use Pages to Generate Individual Slides in PowerPoint for Each Combination of Multiple Field ...

Note that these tutorials reference NPrinting 16 and QlikView, but they should still apply to NPrinting 17 and Qlik Sense. Please let me know if these do not resolve your issue.

rglenn0780
Contributor

Re: QlikSense NPrinting Questions

Hi Stephen,

First off, thank you so much for getting back to me. I am working problem 1 currently, I only have one slide per product line information. The first one is slide 2. I know that when I preview the report, it will generate 8 slides because there are 8 product lines that the information is pulling from. Slide 3 is the other information and will generate 8 additional slides (if it is working correctly) of this product line information. Would I set the slide ranges at 2-9 for the first slide and 10-17 for the second.

If it populates correctly, there should be a total of 17 slides not including the first introduction slide to the deck.

I tried this and received an error stating "the preview does not support custom datasets". After this, I published the report and it did not work correctly when viewed without the preview either.

I have yet to try your second recommendation and will post about that one as well.


Again, thank you for sharing your expertise.

rglenn0780
Contributor

Re: QlikSense NPrinting Questions

Also, for number 1...

I created a separate page for each product line object. so the first page is Product Line and the second page is Product Line_1. Not sure if this info is relevant for you.

Thanks

Employee
Employee

Re: QlikSense NPrinting Questions

Russell - you want to have the slide numbers as 2-3 in the page properties.

Does the dimension you are trying to page thru include any calculations?

rglenn0780
Contributor

Re: QlikSense NPrinting Questions

Stephen,

I applied one page at 2-3 and tried just on slide 2 and just on slide 3 - this in preview just came out with those single slides. Would I need to create 2 separate product line pages and place them on the separate slides and put 2-3 on each of their properties?

Thanks

-I do not believe the page has any calculations

Employee
Employee

Re: QlikSense NPrinting Questions

No, you should just need to add the page to slide 2 and then in the properties for the page, list slides 2-3.

Can you provide a screenshot(s) of the template in the appropriate slides?

rglenn0780
Contributor

Re: QlikSense NPrinting Questions

It worked! Thank you kind sir....I will let you know how number 2 goes.

Employee
Employee

Re: QlikSense NPrinting Questions

Excellent! Please let me know...

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

rglenn0780
Contributor

Re: QlikSense NPrinting Questions

Morning sir,

I am working through question 2....

I am struggling with finding out how to create a "table box" in the qlik sense application. Do you know where I would go in qlik sense to achieve these dimensions for NPrinting sorting? I cannot seem to find table box anywhere just a standard table.

Thanks!

Community Browser