topic Re: Table too large for the page in Qlik NPrinting

Table too large for the page

kevinchevrier — Mon, 30 Oct 2017 14:15:29 GMT

Hi,

I have a table with ten columns for example. So this table is too large and is cut in Powerpoint.

How can I do to keep all column ?

With word, I can do level to split my table into 2 tables (or more). How can I fix it in Powerpoint ?

Kevin

Re: Table too large for the page

Lech_Miszkiewicz — Wed, 01 Nov 2017 03:39:57 GMT

Hi Kevin

My solution may seem ridiculous but it actually may work.Here is what i suggest:

Please calculate how many rows in the table you are able to fit on one Power Point Slide, (for the sake of this exercise lets just assume that on one slide you want a table with only 3 rows)
Once you have a number of rows figured out, you should be able to create a field in your data model which will drive your table splits into slides using NPrinting PAGE functionality
- example: i want to present sales by country (my countries are, USA, Argentina, Australia, Germany, GB, France, Poland, Russia, Czech, Slovakia
  - In script i would create a field which for each of those countries would assign a numerical value which will be used in PAGE node in NPrinting. the assignment of the value can be based on alfa-numerical order or maybe on a measure which would have to be pre-aggregated in script. The only trouble is if you have multidimensional table then you have to create multidimensional key.
    - USA = 1
    - Argentina = 1
    - Australia = 1
    - Germany =2
    - GB = 2
    - France = 2
    - Poland = 3
    - Russia = 3
    - Czech = 3
    - Slovakia = 4...... etc
- then i would use my value 1,2,3,4 as a page node and would apply it to slide where my table is. This would create 4 slides and would filter dataset for each of them based on values assigned to countries
- voila - i know it is not as easy as it seems, but can potentially work for you.

Additional comments:

depending on your measure you may need to precalculate measures in script in order to skip empty records for dimensions (with 0 value)
You may need to sort your main dimension by your measure in script; use Ceil(Rown ()/ X) as my field where X is number of rows which fit on one page i PPT
It is not a straight forward solution but with little bit of thinking it can be done perfectly fine - i think.

hope this will give you some idea, or maybe help you different solution.

rpc‌ - Ruggero, i remember you gave some examples how to fit tables in PPT, but could not find it on community. Could you please also give your thoughts when you get a chance? I think it was in regards to ho to split table between multiple slides, but number of slides was not dynamic i n your example i think.

cheers

Lech

Re: Table too large for the page

Ruggero_Piccoli — Thu, 02 Nov 2017 09:05:16 GMT

Hi Lech,

1 - I agree with your solution and I would to suggest this approach specially when you don't know at the beginning the total number of rows that the table will contain. The cons is that you need to do (a small) change in the load script.

2 - If you know how many total rows the table has you can use the Custom Rows property

The advantage is that you don't need to change the script but you have to add the same object multiple times and set a range of rows for each.

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: Table too large for the page

Lech_Miszkiewicz — Thu, 02 Nov 2017 20:49:45 GMT

This is also cool as you may be aware that the list of rows will be range between X&Y so then you dont have trouble yourself to do what i have suggested.

thanks Ruggero

Kevin, what are your thoughts on this?

Re: Table too large for the page

kevinchevrier — Fri, 03 Nov 2017 08:21:06 GMT

Hello,

Thank you for your answer.

Actually, the issue is not on the number of rows, but it concerns the number of columns.

Kevin

Re: Table too large for the page

kevinchevrier — Fri, 03 Nov 2017 08:21:20 GMT

Hello,

Thank you for your answer.

Actually, the issue is not on the number of rows, but it concerns the number of columns.

Kevin

Re: Table too large for the page

Ruggero_Piccoli — Fri, 03 Nov 2017 13:03:46 GMT

You could follow this https://help.qlik.com/en-US/nprinting/September2017/Content/PowerPointReports/HowInsertNativeTablePowerPointReports/Nati…:

add the Qlik Straight table in the Tables node
Expand the columns by clikking the + symbol
Drag and drop the columns into the template
Set the column width
Run a Preview

Best Regards,

Ruggero

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

Re: Table too large for the page

AtQlik — Tue, 05 Jan 2021 05:00:21 GMT

Is Custom Rows property exist for Qlik sense to NPrinting connection. I assume it is only for Qlikview to NPrinting. I tried to locate custom rows in NPrinting couldn't find it.

FYI - I am using Qlik Sense for my data to NP report

Re: Table too large for the page

Frank_S — Tue, 05 Jan 2021 15:22:45 GMT

@AtQlik

Please start a new question in the NP community as your question is not directly related to this three year old thread. I can help you in the new thread.

Thank you.