topic filling up values in QlikView

filling up values

Frank_Hartmann — Fri, 30 Jan 2015 17:38:12 GMT

hello qv community,

my script looks like this:

------------------------------------------------------------------

LOAD

RowNo() as Position_,

num(textbetween(@1,'<th rowspan="1" scope="row">','</th>')) as Jahr_

FROM

[Source]

LOAD

RowNo()-1 as Position_,

textbetween(@1,'<td>','</td>') as Werte

FROM

[Source]

-------------------------------------------------------------------

Now I load a table with Position_, Jahr_, Werte in Qlikview

The Output looks like this:

Now I need all the year values to be filled up 5 rows upwards (for example:1997 also in Position_ :588-592

1996 also in Position_ :596-600)

Can somebody explain me how to setup the script?

Thx in advance for helping

Re: filling up values

sujeetsingh — Fri, 30 Jan 2015 17:48:15 GMT

You can play with Previous function to achieve your need.

Re: filling up values

prieper — Fri, 30 Jan 2015 18:53:56 GMT

Think that previous may not work, give it a try with the below

BaseTable:

LOAD ROWNO() AS Pos, * INLINE [Jahr, Werte

, 5

, 6

, 7

2010, 2

, 1

, 2

, 3

2011, 1];

Table:

NOCONCATENATE LOAD

Pos,

Werte,

IF(LEN(TRIM(Jahr)) = 0, PEEK('Jahr', -1), Jahr) AS Jahr

RESIDENT

BaseTable

ORDER BY

Pos DESC;

DROP TABLE BaseTable;

HTH Peter