Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

vikasmahajan
Honored Contributor III

Page Wise Straight Table & Associated List box with Rank Function

Dear All,

I have data of Targets , I want to display this data Page Wise ( Page 1,2,3,4.... etc)  and list box associated with straight table records using rank function.

Please can any one help me to achieve the same.

Thanks in advance.

Vikas

3 Replies
MVP
MVP

Re: Page Wise Straight Table & Associated List box with Rank Function

Hi Vikas,

Check this link below

Paging Implementation for Straight table


Hope it helps you.


Regards,

jagan.

vikasmahajan
Honored Contributor III

Re: Page Wise Straight Table & Associated List box with Rank Function

Thanks Jagan  I have 13 records per page will group with 13 work with your solution ?

Vikas

MVP
MVP

Re: Page Wise Straight Table & Associated List box with Rank Function

Hi,

Change the script like below

LOAD [IP Address],

     [1WK],

     [9WKS],

     [07WKS],

     div(rowno(), 13) + 1  as Group

FROM

\\TB01_20120927_110402.xls

(biff, embedded labels, table is Sheet1$);

Then it work as you expected.

Regards,

jagan.

Community Browser