topic Re: Finding NULL (missing) values in QlikView

Finding NULL (missing) values

Thu, 19 Jul 2012 16:23:50 GMT

Hello community,

i have a problem with finding missing values.

The Database was programmed quite efficient, so there are no empty cells.

if there is an hour with no data, the whole line with

S_ID, hour, UNIT, DATA

is not written.

I tried some of the usual expressions to find NULL, but it doesnt work here.

IF(len(DATA)=0,'NULL')

IsNull(DATA)

the cells are not empy, they just dont exist.

its like a box full of eggs, i should have 10, but i get a box of 6. since the box of 6 is FULL, there seems to be no error, BUT 2 eggs are missing.

i thought about somehow connecting the DATA and a HOUR field from a seperate calendar.

The table looks like this

S_ID	hour	UNIT	DATA
5	1	1	20
5	2	1	15
5	3	1	8
5	6	1	3
5	7	1	8

any suggestions ?

CGJA — Thu, 19 Jul 2012 16:28:02 GMT

no se si ya hallas probrado con el Null()

SI (len (DATA) = 0, 'NULL()')

IsNull (DATA)

saludos espero te ayude

Thu, 19 Jul 2012 16:39:10 GMT

i have allready tried that, this doesnt work. the field is not empty, the whole row is missing,

because of the missing rows, peek() is not working too.

i somehow have to check every hour, if there is a corresponding DATA field. if not, 'NULL'