Loop with autofill?

Fri, 06 May 2011 11:13:12 GMT

Hi,

I have a simple loop - see attachement - that are returning values for a prognosis calculation. I had to loop this to be able to connect to other tables, because there's no useful dates in the table, just a date when the post is created.

One value should be used until a new value appear in that column, like:

P12 a b

P1 - -

P2 c d

P3 - -

and so on. So the value for P1 should be the last recorded = P12 and for P3 = P2

So I must have the loop to "autofil" the last existing values where the fields are empty or null. Like:

P12 a b

P1 a b

P2 c d

P3 c d

and so on...

Is there a way to do that?

/@Ungvall

Loop with autofill?

rbecher — Fri, 06 May 2011 17:57:38 GMT

Hi Torbjörn,

just to give you an idea, this works:

base:

LOAD * INLINE [

F1, F2, F3

P12, a, b

P1, ,

P2, c, d

P3, ,

];

autofill:

LOAD F1 as Field1,

if(IsNull(F2) or Trim(F2)='', peek(Field2), F2) as Field2,

if(IsNull(F3) or Trim(F3)='', peek(Field3), F3) as Field3

Resident base;

- Ralf

topic Loop with autofill? in QlikView

Loop with autofill?

Loop with autofill?