topic Re: Custom rows property on NPrinting designer in Qlik NPrinting

Custom rows property on NPrinting designer

VinayakKhavanekar — Mon, 11 Nov 2024 10:33:58 GMT

I could not find the custom rows property on Qlik NPrinting Designer. I have the Feb - 2024 version.

I am using a table and want to divide the number of rows for each page.

I am expecting to get the following property fields

when I select a table, I can only see the following property fields

@Bastien_Laugiero @Michael_Tarallo @Sebastian_Linser @ToniKautto @Kushal_Chawda @Qrishna @anat @VBD @KDev1

Re: Custom rows property on NPrinting designer

Lech_Miszkiewicz — Mon, 11 Nov 2024 10:59:31 GMT

Hi @VinayakKhavanekar

You are using Qlik Sense. This is QlikView only property.

cheers

Re: Custom rows property on NPrinting designer

Lech_Miszkiewicz — Mon, 11 Nov 2024 11:27:29 GMT

also - depending on your template (what is it? Excel? PPT? HTML? HTML?) we may find other workarounds to achieve the same result. So you may want to share little bit more light on how your template looks like and how you want your final result to look.

cheers

Re: Custom rows property on NPrinting designer

VinayakKhavanekar — Mon, 11 Nov 2024 11:57:34 GMT

Hi Lech_Miszkiewicz,

Thanks for your reply. Also, we want to show data in a PPT report, where the content or table gets extended, and then it should go on the next slide of the PPT.

Is there any workaround for dynamic data-wise slide creation?

Re: Custom rows property on NPrinting designer

Lech_Miszkiewicz — Mon, 11 Nov 2024 12:27:48 GMT

Hi @VinayakKhavanekar

It depends. as I said we would need to see your requirements (in details).

If you tell me that your table has say 5 dimensions and each dimension has say 100 possible values then I say getting it right in PPT will be challenging.

but if it is a table which may have say 1-2 dimensions and data is relatively small and can be partially precalculated in the script I would say you could workout and create a dimension in load script which could be used as a page node in PPT template.

then there is a question of whether user filters are in use or whether section access is in use.

cheers

Re: Custom rows property on NPrinting designer

VinayakKhavanekar — Mon, 11 Nov 2024 13:23:36 GMT

There are 7 dimensions in a pivot table and a single measure and a certain sorting order is applied.

Regarding using page feature, I think it won't split a single pivot table in 2 or more slides depending on the number of rows.

Please suggest any other alternative, if any.

Re: Custom rows property on NPrinting designer

Lech_Miszkiewicz — Tue, 12 Nov 2024 09:21:36 GMT

Hi @VinayakKhavanekar

I said it will not be easy task but it can be done. In short you will have to create a concatenated key in your data model by using all fields (which are used as rows) from your pivot table and in script in which you will also have to calculate the actual measure for it just to know which dimesnion values actually produce the measure for whatever filters you apply to that report.

Once you have aggreagated table like that you would have to assign unique key (dimension) which would represent bundle of rows you want to put on single slide in PPT NPrinitng report. You then assign that new dimension value to your concatenated key.

Once in NPrinting you use that dimension as a page node - thats it.

Bellow you see an example with only 3 dimensions representing steps you would need to do in your Qlik Sense load script to prepare data.

you see 3 dimensions (you would have to use 7)
you see concatenated key based on those 3 dimensions (you would have to use 7)
you see a PageDim dimensions which groups those key.

When used in NPrinting that PageDim would produce a data of 10 rows for each slide... (you can come up with grouping based on your requirements)

Thats general concept of it, but I understand that it may not be easy to implement.

Ohhh - I dont see any other solution or workaround than that. Would be happy to see if others could comment on this but it is unlikely.

cheers