Paging for qlikview straight table and pivot table

[kishorj1982]

Hi all,

PFA.

I have number of records in my chart can you please suggest how shall I implement paging concept for this.

Thanks,

Kishor

[prma7799]

Please check below application ....

[kishorj1982]

This is for table box/

I was unable to apply this in straight and pivot table.

Attached is my application.

Plz suggest.

Thanks

[ElizaF]

Hello,

See attach file.

What is important in this solution is to define the variable vPageCount.

Hope to help you. !

[kishorj1982]

Eliza,       

This is what In excepted. Thanks for your valueable response.

But I have created Header1 and Header2 for below calculation can you please suggest how shall I use that in your formulae.

LOAD
*,
if(Match(CRD_Limit_Status, 'Over Credit Limit', 'Under Credit Limit'),  Cust#_Name)  AS Header1,
if(Match(CRD_Limit_Status, 'Over Credit Limit'),  Cust#_Name)  AS Header2;

Thanks,

                                                                                                                                                                                                                                                                                                           `

[ElizaF]

I thing it is for two different reports?!

In this case you must have two variables:

For vPageCountHeader1 exppresion:

=Ceil(Count(DISTINCT{<Cust#_Name=,OpenAR_USD= {"<0"}>}Header1)/vRows)

For vPageCountHeader2 exppresion:

=Ceil(Count(DISTINCT{<Cust#_Name=,OpenAR_USD= {"<0"}>}Header2)/vRows)

And in the chart - Dimension

=Aggr(

     If(Rank(Aggr($(vTotalOpenAR),Header1)) >= vRankFrom

          And Rank(Aggr($(vTotalOpenAR), Header1)) <= vRankTo, Header1),

       Header1)

I hope you not have the error, because in your file doesn't exist the Header1 and Header2 fields.

Eliza

[Kushal_Chawda]

see this

Paging Implementation for Straight table