topic Re: Straight table data need to separate by row as batch wise in QlikView

Straight table data need to separate by row as batch wise

Fri, 06 May 2016 18:09:59 GMT

I have raw data with 1000 records,my requirement is we have straight table with 600 rows in front End.Based on this chart i need to break the data like below

Batch1 (1-100 rows)

Batch2 (101-200 rows)

Batch3 (201-300 rows)

Batch4 (301-400 rows)

Batch5 (401-500 rows)

Batch6 (501-600 rows)

in frond end i need a list box:

Batch1

Batch2

Batch3

Batch4

Batch5

Batch6

if i click on Batch1 the first 100 rows(1-100 rows) should display,if i click on Batch2 the second 100 rows(101-200 rows) should display... in the straight table etc

thanks

Re: Straight table data need to separate by row as batch wise

Peter_Cammaert — Fri, 06 May 2016 19:01:06 GMT

Add this column definition to the LOAD statement that loads the 1000 records of raw data:

LOAD

'Batch' & ceil(RowNo()/100) AS BatchNumber,

FROM ...

Best,

Peter

Re: Straight table data need to separate by row as batch wise

Fri, 06 May 2016 20:29:24 GMT

Hi peter

thanks for reply.

I did same thing in scripting.it is pulling raw data as 10 batches which i don't required.i want only 6 batches the data which is there in the straight table not in the raw data becoz in the straight table only specified data is pulled using by expression that data should be divided into equal ranges.

Thanks