Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

FILLING BLANK CELL

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

1 Solution

Accepted Solutions

Re: FILLING BLANK CELL

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

5 Replies

Re: FILLING BLANK CELL

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

Not applicable

Re: FILLING BLANK CELL

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

Re: FILLING BLANK CELL

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

Not applicable

Re: FILLING BLANK CELL

can u show me how...

the row table like attached above.

i am a newbee

Not applicable

Re: FILLING BLANK CELL

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

Community Browser