topic Re: QlikSense NPrinting Questions in Qlik NPrinting

QlikSense NPrinting Questions

Anonymous — Wed, 12 Jul 2017 19:19:51 GMT

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...

Re: QlikSense NPrinting Questions

Stephen_Jasionowski — Thu, 13 Jul 2017 16:49:32 GMT

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 Values

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.

Re: QlikSense NPrinting Questions

Anonymous — Thu, 13 Jul 2017 18:06:43 GMT

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.

Re: QlikSense NPrinting Questions

Anonymous — Thu, 13 Jul 2017 18:09:34 GMT

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

Re: QlikSense NPrinting Questions

Stephen_Jasionowski — Thu, 13 Jul 2017 18:17:19 GMT

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?

Re: QlikSense NPrinting Questions

Anonymous — Thu, 13 Jul 2017 18:24:59 GMT

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

Re: QlikSense NPrinting Questions

Stephen_Jasionowski — Thu, 13 Jul 2017 18:39:32 GMT

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?

Re: QlikSense NPrinting Questions

Anonymous — Thu, 13 Jul 2017 18:40:09 GMT

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

Re: QlikSense NPrinting Questions

Stephen_Jasionowski — Thu, 13 Jul 2017 19:46:34 GMT

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.

Re: QlikSense NPrinting Questions

Anonymous — Fri, 14 Jul 2017 13:19:07 GMT

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!

Re: QlikSense NPrinting Questions

Anonymous — Fri, 14 Jul 2017 15:56:19 GMT

OK. I was able to create the table box and it does sort down to the Product Line level. I am still struggling though because I want an overall business capability image first then the business capability/product line level to follow. so the order would go...

Business capability (overview of all product lines)

-Product line 1 corresponding to above business capability

-Product line 2 corresponding to above business capability

-Product line 3 corresponding to above business capability

Business capability 2 (overview of all product lines)

-Product line 1 corresponding to above business capability #2

-Product line 2 corresponding to above business capability #2

-Product line 3 corresponding to above business capability #2

so image if you wanted like a sum of financials on first page then individual lines following it then another business capability sum financials then corresponding product lines following it and so on through them all.

Please let me know your thoughts when you can!

Thanks again for all your time

Re: QlikSense NPrinting Questions

Anonymous — Mon, 17 Jul 2017 14:06:47 GMT

sjw‌,

Hopefully the previous post makes sense. If it is confusing, please let me know. Do I mark as correct now or after we troubleshoot question 2?

Thanks again

Re: QlikSense NPrinting Questions

Stephen_Jasionowski — Mon, 17 Jul 2017 15:00:08 GMT

You can keep it marked correct since the original question is answered.

Is there any way for you to do this in the load script? In other words, have a product line such as "All" for each business capability? I'm still thinking out a way to do this with NPrinting filters/pages alone.

Re: QlikSense NPrinting Questions

Anonymous — Tue, 18 Jul 2017 17:02:45 GMT

Thank you so much sir for looking into an NPrinting solution