Discussion Board for collaboration related to Qlik Education.
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?
Go to Solution.
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
There is no attach but try this:
if the field you want to be filled with the previous value is myField then:
if(isnull(myField) or trim(myField)='', previous(myField), myField)
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
can u show me how...
the row table like attached above.
i am a newbee
LOAD IF(ISNULL(Product) OR TRIM(Product)='', Peek(Product1), Product) as Product1,
and the result is right.. is the script above true?