topic Re: Fill value with previous value in QlikView

Fill value with previous value

Anonymous — Sat, 09 Jun 2018 21:41:16 GMT

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:

Re: Fill value with previous value

Chanty4u — Sun, 10 Jun 2018 10:52:01 GMT

try this

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

Re: Fill value with previous value

shiveshsingh — Sun, 10 Jun 2018 16:24:15 GMT

try this

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

LOAD * INLINE [

ID, Value

A, 1.3

B, 4.5

B, 3.4

C, 1.1

];

Re: Fill value with previous value

sunny_talwar — Sun, 10 Jun 2018 20:56:58 GMT

Try this

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

Re: Fill value with previous value

Anonymous — Tue, 26 Jun 2018 17:30:17 GMT

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

I appreciate your support.

Re: Fill value with previous value

Anonymous — Tue, 26 Jun 2018 17:31:30 GMT

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

I appreciate your support.

Re: Fill value with previous value

Anonymous — Tue, 26 Jun 2018 17:37:05 GMT

I share the result

Re: Fill value with previous value

sunny_talwar — Tue, 26 Jun 2018 17:40:50 GMT

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

Re: Fill value with previous value

vishsaggi — Tue, 26 Jun 2018 17:55:15 GMT

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

Re: Fill value with previous value

Anonymous — Tue, 10 Jul 2018 04:55:06 GMT

Thaks, it works