topic Re: Chart scroll and Table rows - NPrinting Powerpoint report in Qlik NPrinting

Chart scroll and Table rows - NPrinting Powerpoint report

reshma_km — Tue, 26 Sep 2017 10:51:14 GMT

Hi,

I need to avoid scroll and show the entire chart in the Powerpoint report. I tried all 5 stretch options, but still scroll is coming. Apart from maximizing the object in QlikSense app in a hidden tab and pointing to it in NPrinting designer template, is there any other way to achieve this?

Another concern is regarding the number of rows for a Powerpoint table. What will happen if the number of rows exceeds 25 or 50 rows?

Re: Chart scroll and Table rows - NPrinting Powerpoint report

ogster1974 — Tue, 26 Sep 2017 13:34:29 GMT

Your App source for NPrinting should ideally be dedicated to that task so no need to hide your chart display it in the best way possible for NPrinting purposes.

For displaying data in tables over a certain row size or variable in nature I would look at using excel. Power point is great for cleanly showing summaries like Top 10 etc...

Re: Chart scroll and Table rows - NPrinting Powerpoint report

Ruggero_Piccoli — Tue, 26 Sep 2017 14:44:51 GMT

When you add a QlikView or a Qlik Sense object as an image it will be exported as it is in the source. So if it has scrollbars in the source the exported version will have scrollbars. The only solution is to modify the object in the source.

To limit the number of rows in a PowerPoint slide you can use the Page node or add the source object many times and set the Custom Rows property.

Best Regards,

Ruggero

---------------------------------------------

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: Chart scroll and Table rows - NPrinting Powerpoint report

reshma_km — Wed, 27 Sep 2017 09:27:46 GMT

Thanks.

Can we set this dynamically? The number of rows is not fixed. I would like to display 1-10 rows in slide1 and 11-20 in slide 2. But the number of rows ban be 8 or 22 also. Is there anyway to dynamically set this?

Re: Chart scroll and Table rows - NPrinting Powerpoint report

Ruggero_Piccoli — Wed, 27 Sep 2017 10:01:43 GMT

No, you cannot set the beginning and ending row dinamicaly.

You can use only fixed values.

Re: Chart scroll and Table rows - NPrinting Powerpoint report

reshma_km — Wed, 27 Sep 2017 10:15:34 GMT

is it possible to apply conditional visibility to the entire slide? like, when no of rows>10, show slide2, else don't.

Re: Chart scroll and Table rows - NPrinting Powerpoint report

reshma_km — Wed, 27 Sep 2017 12:10:50 GMT

Hi,

I don't see "custom rows" under "properties". I can see only till "keep source formats". Is it so for NPrinting 17.3?

Re: Chart scroll and Table rows - NPrinting Powerpoint report

Ruggero_Piccoli — Wed, 27 Sep 2017 12:22:12 GMT

Custom rows is a property at table level and it is not available at column level.

In other words, to see the custom rows property you must select a table. If you select a row of a table you will not see the property.

Re: Chart scroll and Table rows - NPrinting Powerpoint report

reshma_km — Wed, 27 Sep 2017 12:38:23 GMT

I have selected a table only. Please see the screenshot below. I have selected the table masked in red.

Re: Chart scroll and Table rows - NPrinting Powerpoint report

Ruggero_Piccoli — Wed, 27 Sep 2017 12:51:24 GMT

I understand, you are working with objects from Qlik Sense and Custom Rows is not yet available for Sense tables.

It is in the roadmap but I don't know when it will be available.

Re: Chart scroll and Table rows - NPrinting Powerpoint report

reshma_km — Thu, 28 Sep 2017 08:26:40 GMT

is there any alternatives? can I do this from powerpoint perspective? is there any powerpoint option to split a table over multiple slides or display a subset of rows and conditionally show/hide slide?

Re: Chart scroll and Table rows - NPrinting Powerpoint report

Ruggero_Piccoli — Mon, 02 Oct 2017 07:16:31 GMT

As alternative you can use the Page feature. If you insert a field in the Page node you will get a different slide for each value of the field added in the Page node.

In this case you don't know before the number of rows you will get in the final table. To avoid this you could create a specific field in the original app just to split the table.

Best Regards,

Ruggero

---------------------------------------------

Re: Chart scroll and Table rows - NPrinting Powerpoint report

reshma_km — Tue, 03 Oct 2017 11:21:29 GMT

That sounds great. I will try and let you know if it works out.

Re: Chart scroll and Table rows - NPrinting Powerpoint report

reshma_km — Wed, 04 Oct 2017 08:02:23 GMT

I created a serial number column for the Qliksense table as the first column using aggr and RowNo functions. Then divided by 15 ( I want 15 rows per slide) and applied ceil function to the column. So serial number 1 means those 15 rows goes to slide1 etc. I thought to apply page feature on this calculated column (It is added as a calculated dimension). But its not working.

Re: Chart scroll and Table rows - NPrinting Powerpoint report

Ruggero_Piccoli — Wed, 04 Oct 2017 08:05:52 GMT

Hi,

You need to add this new field in the loading script in order to create a new field directly in the data set. I suppose you are adding it in a straight table instead as a calculated dimension.

Best Regards,

Ruggero

---------------------------------------------

Re: Chart scroll and Table rows - NPrinting Powerpoint report

reshma_km — Wed, 04 Oct 2017 08:07:39 GMT

yes, i am adding it in straight table

Re: Chart scroll and Table rows - NPrinting Powerpoint report

reshma_km — Wed, 04 Oct 2017 08:09:11 GMT

i wanted to create it dynamically. i don't care about the order or serial number. i just want to split the table to groups of 15 rows and display each group in a seperate slide.

Re: Chart scroll and Table rows - NPrinting Powerpoint report

Ruggero_Piccoli — Wed, 04 Oct 2017 08:11:37 GMT

Calculated dimensions are not supported in the Page node. You must add the same field in the load script and the into the Page node.

Re: Chart scroll and Table rows - NPrinting Powerpoint report

reshma_km — Wed, 04 Oct 2017 08:14:24 GMT

Ok. Thank you

Re: Chart scroll and Table rows - NPrinting Powerpoint report

reshma_km — Fri, 06 Oct 2017 09:05:16 GMT

Hi, I am not able to create a page field in the script side. Is there any way to format a table with more than 20 or 50 rows to fit into a single slide?