topic Re: FILLING BLANK CELL in Qlik Learning Discussions

FILLING BLANK CELL

Wed, 26 Nov 2014 07:40:23 GMT

Hi,

i have raw data table, but not all the cell filled

if i want to load the table in qlikview but the cell being filled with the data abve the column.

sample raw table & result expected attached (2 sheet)

what should i do?

Thanks

Steven

alexandros17 — Wed, 26 Nov 2014 07:45:38 GMT

There is no attach but try this:

if the field you want to be filled with the previous value is myField then:

Load

...

if(isnull(myField) or trim(myField)='', previous(myField), myField)

...

resident myTable

Wed, 26 Nov 2014 08:26:41 GMT

oops,

i have tried your solution above...

the result only fill the first blank row wtih the previous value.

when going to the next blank row, it still remain blank because the previous one is null also.

my data have more than one blank row... all the blank row should be filled with the last filled

Thanks

Steven

alexandros17 — Wed, 26 Nov 2014 08:31:48 GMT

You're right .... so you should try a loop where you take the value with peek function and if next record has non value you use the stored value

Wed, 26 Nov 2014 08:37:34 GMT

can u show me how...

the row table like attached above.

i am a newbee

Wed, 26 Nov 2014 09:13:29 GMT

Dear Alessandro,

LOAD IF(ISNULL(Product) OR TRIM(Product)='', Peek(Product1), Product) as Product1,

Date,

Transaction

From

[H:\....

and the result is right.. is the script above true?

Thanks

Steven