topic Re: Use previous in QlikView

Use previous

Thu, 12 May 2016 08:48:44 GMT

Hello,

I´m loading a text file with orders and some of the detail order lines contains a number but some of the other

does not. My aim is to add the number to all records within the order. An excerpt of the text file looks like this:

with this line in my script can I only fill in 506 in the first record after 506 and the others will remain empty.

This is what I get:

How do I get the lines with 'ST' empty filled with 506?

kindly

Håkan

sunny_talwar — Thu, 12 May 2016 08:50:31 GMT

Try this:

If([@350:359] = Previous([@350:359]) and [@484:486] = ' ', Peek('ST'), [@484:486]) as [ST]

If([@350:359] = Previous([@350:359]) and Len(Trim([@484:486])) = 0, Peek('ST'), [@484:486]) as [ST]

Thu, 12 May 2016 08:58:00 GMT

Thanks for VERY fast answer. I took 5 times longer time to create the question than get the answer.

Awsome.

kindly

Håkan