Paging function in PPT Template

[sijojoseph22]

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

[vikasmahajan]

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

[sijojoseph22]

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

[jonathandienst]

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.

[Anonymous]

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.

[Colin-Albert]

Do these tutorials posted by stephen.jasionowski help?

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

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

QlikView NPrinting Tutorials - PowerPoint Reports

[iventurini]

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

[sijojoseph22]

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

[#9]

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

[sijojoseph22]

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