topic Re: Diviser un tableau en Nprinting in Qlik NPrinting

Diviser un tableau en Nprinting

sylvain_piccarreta — Sat, 16 Nov 2024 04:29:54 GMT

Bonjour

j'ai un tableau qlikivew qui peut contenir un nombre varié de lignes suivants un filtre. Or, lorsque je le passe via Nprinting, il se peut que sur certaines diapos, le tableau ne devient pas lisibles car trop de lignes. Comment puis-je procéder afin par exemple de n'afficher sur une diapo le tableau avec les 30 premieres lignes, une deuxième les 30 suivants et ainsi de suite.

Merci par avance

Sylvain

Re: Diviser un tableau en Nprinting

Ruggero_Piccoli — Mon, 11 Feb 2019 13:23:05 GMT

Hi,

First of all, please post your questions in English to maximise the possibilities to be helped. Second please always specify the version of Qlik NPrinting you are using and the kind of template you are developing.

Based on your question I suppose you are developing a PowerPoint template. In PowerPoint you could add a field in the Pages node to create a different page for each distinct value of the field.

In PowerPoint templates you could also use the Custom Rows option. In this case you need to add the same table multiple times and for each one specify the beginning and ending row as fixed numbers. Note that PowerPoint itself is not designed to manage huge tables, in that case it is better to use Excel.

Best Regards,

Ruggero

Re: Diviser un tableau en Nprinting

sylvain_piccarreta — Mon, 11 Feb 2019 14:26:36 GMT

thanks for your advise and help.

I use the Nprinting June 2018

Version : 18.19.6.0

and I can't see the choice Customs Rows. Is it available in this version or I need tu update it ?

thanks again

Re: Diviser un tableau en Nprinting

Ruggero_Piccoli — Mon, 11 Feb 2019 14:46:14 GMT

Custom Rows property is available in June 2018. See https://help.qlik.com/en-US/nprinting/June2018/Content/PowerPointReports/Native-table.htm.

You need to add the table in the Tables node, click over it and open the Properties window as you see in the screenshot.

Best Regards,

Ruggero

Re: Diviser un tableau en Nprinting

sylvain_piccarreta — Mon, 11 Feb 2019 15:21:30 GMT

Strange, because, I don't have the choice

Re: Diviser un tableau en Nprinting

Ruggero_Piccoli — Mon, 11 Feb 2019 15:31:08 GMT

Hi,

To see the Custom Rows property you have to add a straight table. These seems pivot tables because you don't see the columns.

Best Regards,

Ruggero

Re: Diviser un tableau en Nprinting

sylvain_piccarreta — Wed, 13 Feb 2019 10:00:37 GMT

right. I will modify my table and try.

Thanks for your help

Re: Diviser un tableau en Nprinting

sylvain_piccarreta — Mon, 18 Mar 2019 10:04:22 GMT

it doesn't fit. because, when I transform my pivot table in straigh table, I lose my dimension in horizontal format.

BY example

I have data for each store for 1 year below, an example of format.

and I need to put in the format below :

in pivot table, I know how to do it, but in straight table, no, I can't move the period in different position and format.

thanks,

Regards,

Sylvain

Re: Diviser un tableau en Nprinting

Ruggero_Piccoli — Mon, 18 Mar 2019 11:22:25 GMT

Hi,

Did you tried to use the Pages feature?

Best Regards,

Ruggero