Fill value with previous value

[Anonymous]

I want to fill empty cell with the previous value where is not null, this is possible?

i do this

 if( (IsNull(Value) or Value= 0) and ID= Previous(ID), Previous(Value), Value)

but only fill the previous value.

Example:

[Chanty4u]

try this

     If(Value, Value, Peek(Value1)) as Value1

[shiveshsingh]

try this

load ID,if(ID=Previous(ID) and Len(Value)=0,Peek(Value), Value) as Value;

LOAD * INLINE [

    ID, Value

    A, 1.3

    A

    A

    B, 4.5

    B

    B, 3.4

    B

    C, 1.1

    C

    C

    C

];

[sunny_talwar]

Try this

if((IsNull(Value) or Value= 0) and ID= Previous(ID), Peek('New_Value'), Value) as New_Value

[Anonymous]

Hi shiveshsingh , it does not work, just fill one of the empty records. The others remain empty.

I appreciate your support.

[Anonymous]

Hi stalwar1, it does not work, just fill one of the empty records. The others remain empty.

I appreciate your support.

[Anonymous]

I share the result

[sunny_talwar]

table box always show the unique combination of your dimension... For example if ID = A and Value = 1.3 repeats 10 times, it will still be shown only once in your table box object.

This image proves that what you wanted actually worked, because it it didn't then you would have seen two rows for A... one with 1.3 and the other with null

[vishsaggi]

can you share that qvw file where you see those empty records and also share your script what you were running.

[Anonymous]

Thaks, it works