topic copy first value in lines above in QlikView

copy first value in lines above

Mon, 21 Dec 2015 13:15:35 GMT

Hello,

Can anyone help me with a function in script which inputs in Load the Command value in each line?

For example, I have the command 420803 with 3 positions and I need to appear the command value in each line.

Same for command 420890 and other more if needed.

Thank you!

sunny_talwar — Mon, 21 Dec 2015 13:49:47 GMT

Try Peek() function:

Table:

LOAD If(Len(Trim(Command)) = 0, Peek('Command'), Command) as Command,

Position

FROM

[https://community.qlik.com/thread/197295]

(html, codepage is 1252, embedded labels, table is @1);

sinanozdemir — Mon, 21 Dec 2015 13:52:12 GMT

Hi,

Maybe something like this:

And here is your data model:

I am also attaching qvw.

Hope this helps.