Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.
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.
Hi Sijo,
I have a a similar problem...
I have read your post:
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
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
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
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