topic Clear null fields of a table in QlikView

Clear null fields of a table

marcel_olmo — Mon, 24 Jan 2011 19:55:54 GMT

Hey guys, I got stuck in this apparently simple thing, but I still can't solve it.

I put a simple example to make you understand :

If I have a table like this :

How can I get this result (cleaning all the null values, and storing the results in one row):

Field1, Field2, Field3, Field4

1 , 2 , 3 , 4

Hope someone can help me telling me how can I do that.

Many thanks in advance!! Cheers!

Clear null fields of a table

Anonymous — Mon, 24 Jan 2011 20:07:17 GMT

Clear null fields of a table

hector — Mon, 24 Jan 2011 20:50:21 GMT

Load

field_to_group,
max(Field1) as Field1,
max(Field2) as Field2,
max(Field3) as Field3,
max(Field4) as Field4
from/resident table
group by
field_to_group
;

But, if you have other field to group, use the yellow code too

Rgds

Clear null fields of a table

marcel_olmo — Wed, 26 Jan 2011 16:07:49 GMT

Thanks Hector, this is the kind of easy things you got stuck once in a while.

In addition, if you have the same with characters, you can use maxstring() as well.

See you around