topic Expression in Script in QlikView

Expression in Script

Mon, 01 Aug 2011 14:09:04 GMT

Good day

I have a data source from excel as below:

i want to create a condition that creates a third column (KEY) as below:

if (Position = '', Value, 'an expression that copy the row above in KEY column')

I'm not able to find this expression or any another solution for this.

lironbaram — Mon, 01 Aug 2011 14:13:29 GMT

hei

use this expression in the load script

if (Position = '', Value,peek('KEY') as KEY

Mon, 01 Aug 2011 14:19:39 GMT

perfect, tks!

Mon, 01 Aug 2011 20:07:48 GMT

liron baram wrote:
hei
use this expression in the load script
if (Position = '', Value,peek('KEY') as KEY

hi.
It does not work for me.

Can you publish the entire script?

Thanks,
Daniel

Mon, 01 Aug 2011 20:08:59 GMT

hi.
It does not work for me.!

Can you publish the entire script?

Thanks,
Daniel

Mon, 01 Aug 2011 20:12:19 GMT

Hi.
It does not work for me. Can you publish the entire script?

Thanks,
Daniel

Mon, 01 Aug 2011 20:18:22 GMT

Daniel, pls check if this can help you:

LOAD

Position,

Value,

if (Position = '', Value, peek(Position)) as KEY

FROM [...]

Rgds,