topic Cycle in Script in QlikView

Cycle in Script

brunopaulo — Wed, 25 Nov 2020 16:16:04 GMT

Hi comminity,

I have a table like a following one

Field 1 | Field 2 | Field 3

A test1 fjhafjhf

A fjhsfjhf

A jfhuhf

A test2 fjskfhdkf

A fjkksafjfads

B fhagdhsgd

B sijisjff

C dfjfjfk

Expected outcome

Field 1 | Field 2 | Field 3

A test1 fjhafjhf

A test1 fjhsfjhf

A test1 jfhuhf

A test2 fjskfhdkf

A test2 fjkksafjfads

B fhagdhsgd

B sijisjff

C dfjfjfk

Im loading several excel files and each one has 1 table like the first.

i want to do a cycle for each file to do this table a peek field2 a replace the null value for above until field1 is A. when b appear on field 1 stop fill and let the empty space.
I tryed some differente ways nothing seems to work.
Any ideas?

Thanks in advance

Best Regards,

Bruno Paulo

Re: Cycle in Script

prieper — Tue, 05 Dec 2017 10:22:42 GMT

Did you check the wizard when creating the script? under "Transform" and then "Fill"?

Re: Cycle in Script

avinashelite — Tue, 05 Dec 2017 10:23:15 GMT

Try like this in the script

if( len(trim(Field2))=0,peek('Field2'),Field2) as Field 2

Re: Cycle in Script

brunopaulo — Tue, 05 Dec 2017 10:25:15 GMT

Yes, but i dont like wizard. It only makes static codes. For this case can result but any change on excel file will return errors.

Re: Cycle in Script

Colin-Albert — Tue, 05 Dec 2017 10:26:12 GMT

Hi Bruno,

Have you seen this post? Generating Missing Data In QlikView

The example "Propagate a value downwards " covers your situation, though you will need to add another test to check if Field1 = peek(Field1) to see if the value has changed from the previous row.

Re: Cycle in Script

brunopaulo — Tue, 05 Dec 2017 10:28:38 GMT

Exactly what i needed. (couldnt found this, thank you!)

Re: Cycle in Script

brunopaulo — Tue, 05 Dec 2017 11:14:47 GMT

with some work this result as well thank you!

Best Regards

Bruno