topic Re: Implementing pagination without macro in QlikView

Implementing pagination without macro

Mon, 16 Jul 2012 12:20:25 GMT

HI,

I have data in the following format

Date, Country, City, Sum(Sales)

01-07-2012,A,X,100

01-07-2012,B,Y,200

01-07-2012,C,z,300

02-07-2012,A,X,400

02-07-2012,B,X,500

02-07-2012,C,X,600

... so on

I need to implement pagination. I want to display 100 rows first and then click on say next button to display next 100 rows.

My constraints are

1) I cannot use macros

2) And, the data for that particular date is complete.

i.e. If say for date 01-07-2012 it has 80 rows and for date 02-07-2012 has 50 rows

then I need to display only 01-07-2012 date as i do not want to split data between dates.

Please suggest!!

Thanks!!

Mon, 16 Jul 2012 13:19:44 GMT

sort table by date and add a counter to the table "Number" // on the load script;)

then create variable (on presentation) "Page"

add two buttons"prev" and "next" (add trigger +1 and -1)

make chart with calculated dimension =if(Number<Page*100 and Number>(Page-1)*100,Number) // it is an idea not a final expression

if you'll do that we'll see what to do with your second question

Thu, 19 Jul 2012 13:05:55 GMT

Hi Pari,

I have one problem here that if i include a counter in the load script,then the counter value cannot be changed.

But i need the counter to be generated dynamically based on the selections.

I dont know how to achieve this.

Fri, 20 Jul 2012 07:44:19 GMT

send a small sample of data, i'll try to fix it