topic Page Wise Straight Table & Associated List box with Rank Function in QlikView

Page Wise Straight Table & Associated List box with Rank Function

vikasmahajan — Wed, 16 Dec 2015 08:57:13 GMT

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

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

jagan — Wed, 16 Dec 2015 09:02:49 GMT

Hi Vikas,

Check this link below

Paging Implementation for Straight table

Hope it helps you.

Regards,

jagan.

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

vikasmahajan — Wed, 16 Dec 2015 09:07:20 GMT

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

Vikas

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

jagan — Wed, 16 Dec 2015 09:19:21 GMT

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.