topic Re: Paging function in PPT Template in Qlik NPrinting

Paging function in PPT Template

sijojoseph22 — Fri, 04 Mar 2016 11:03:31 GMT

Hi All,

We need to page the records based on one pivot/straight Table. The expression will split records based on the no records using class unction. i.e each group 25 records.

Thanks,

Sijo

Re: Paging function in PPT Template

vikasmahajan — Fri, 04 Mar 2016 12:01:23 GMT

You can use Code by jagan Paging Implementation for Straight table

also for exporting into PPT this

Re: Adding Table in PPT Macro PPT

HTH

Vikas

Re: Paging function in PPT Template

sijojoseph22 — Fri, 04 Mar 2016 12:23:54 GMT

Hi Vikas,

We need this to be done at UI level, according to the user selection the number of rows will be different. Hence the script level will not be helpful.

We need this for on demand NPrinting

Thanks,

Sijo

Re: Paging function in PPT Template

jonathandienst — Fri, 04 Mar 2016 12:53:10 GMT

I have an example here: YA(H)Q Blog: Paged charts in Qlikview

I think this is what you are looking for. The post contains full instructions.

Re: Paging function in PPT Template

Anonymous — Fri, 04 Mar 2016 13:46:06 GMT

I just built a PPT document using paging. Can you build a list box and cycle your paging field manually in QV and see the results of your desired paging? If so, then you just need to use that field in your Nprinting report.

Re: Paging function in PPT Template

Colin-Albert — Fri, 04 Mar 2016 13:59:08 GMT

Do these tutorials posted by stephen.jasionowski help?

How to Use Pages to Generate Individual Slides in PowerPoint for Each Combination of Multiple Field Values

How to Use the Page Feature in Excel and PowerPoint Report Templates

QlikView NPrinting Tutorials - PowerPoint Reports

Re: Paging function in PPT Template

iventurini — Mon, 02 May 2016 19:46:35 GMT

Hi Sijo,

I have a a similar problem...

I have read your post:

Adding Table in PPT

where you say you have resolved it by using a flag created with class function. Could you please share the solution?

Thank you in advance

Re: Paging function in PPT Template

sijojoseph22 — Tue, 03 May 2016 10:40:06 GMT

Hi,

You have to create a flag in the script, which will group the records . i.e if you click on one value the first 25 records will be selected and if you click on second the 2nd 25 records will be selected.

Give this flag as paging in the slide you want to use the table.

Thanks,

Sijo

Re: Paging function in PPT Template

Tue, 25 Apr 2017 05:37:43 GMT

Hi Sijo,

Please will you able to explain the solution in detailed manner?

It will be very helpful if I could get screenshots of script and Nprinting , since I'm new to Nprinting and did,'t get idea on how to group the records in a straight table chart.

Thanks in advance!

Regards

Padmini

Re: Paging function in PPT Template

sijojoseph22 — Thu, 11 May 2017 13:08:39 GMT

Hi ,

Assume that you are having 125 records , and planning to display 30 records per slide.

Step1. In QlikView script please create a separate table using the resident load of the table going to display in the slide. Create a flag to group for every 30 records. This can be achieved using the class function.

Step2. Add the flag created as paging in PPT slide.

//Taking the distinct count of the records for Col1 and Col2.

Split_30_Temp:
Load
Distinct
Col1                                                           as [Col1],
Col2                                                            as [Col2],
Col1&Col2                                                   as Link_30split
Resident Tab1
order by Col1,Col2;

//Creating the group for 30 records using the class function and the link will join back to the main table

Split_30:
NoConcatenate
Load
AutoNumber(Rowno(),Link_30split) as split ,
Class(AutoNumber(Rowno(),Link_30split),30,'x',1) as Splitfor30,
*
Resident Split_30_Temp
order by Splitfor30;

Drop Table Split_30_Temp;

Thanks,

Sijo

Re: Paging function in PPT Template

Mon, 05 Jun 2017 06:21:00 GMT

Thank you Sijo!

Re: Paging function in PPT Template

Digvijay_Singh — Thu, 06 Dec 2018 15:58:21 GMT

Any idea how to do the same in Qlik Sense. I cannot add table to Paging node in Qlik Sense. Thanks in advance!