topic Re: Paging for qlikview straight table and pivot table in QlikView

Paging for qlikview straight table and pivot table

kishorj1982 — Fri, 12 May 2017 05:10:30 GMT

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

Re: Paging for qlikview straight table and pivot table

prma7799 — Fri, 12 May 2017 05:36:34 GMT

Please check below application ....

Re: Paging for qlikview straight table and pivot table

kishorj1982 — Fri, 12 May 2017 06:14:56 GMT

This is for table box/

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

Attached is my application.

Plz suggest.

Thanks

Re: Paging for qlikview straight table and pivot table

ElizaF — Fri, 12 May 2017 07:17:17 GMT

Hello,

See attach file.

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

Hope to help you. !

Re: Paging for qlikview straight table and pivot table

kishorj1982 — Fri, 12 May 2017 08:26:00 GMT

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,

Re: Paging for qlikview straight table and pivot table

ElizaF — Fri, 12 May 2017 09:14:06 GMT

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

Re: Paging for qlikview straight table and pivot table

Kushal_Chawda — Fri, 12 May 2017 09:19:23 GMT

see this

Paging Implementation for Straight table