topic Re: Is it possible to count missing values ? in QlikView

Is it possible to count missing values ?

Tue, 15 Jan 2013 13:18:35 GMT

Hi,

herejoin is an application with a table by date / hour.

There may be no data for a date / hour.

In this case QlikView can display in the table either a symbol (ie '-') or a 0.

Chart is fine.

But I would like to count the number of cells without data.

We have to take into account that the selection should be considered. If no hour / date / month are selected, it may be the difference between a count(distinct date) * 24 and the number of cells with data.

But how to proceed if selection are operated (ie : several hours and only a month) ? One of the matter is that the number of days may vary according the selected month.

I am not sure it's possible to realize without adding other data such as a complete calendar for example ?

Thanks a lot for your help !

Re: Is it possible to count missing values ?

Tue, 15 Jan 2013 13:36:15 GMT

try this

IF(isNull(fieldname), 'N/A',fieldname)as fieldname,

then use count() function

hope this helps you.

Re: Is it possible to count missing values ?

Tue, 15 Jan 2013 13:39:18 GMT

you can also try this.

use some expression to idenfity the missing data, such as sum(if("Date"="All Date" and "Item"="All Item",Sales))=0. Your chart will then show only the missing data. Or you can just remove the "=0" to show both present and missing data.

hope this helps you.

Re: Is it possible to count missing values ?

Tue, 15 Jan 2013 16:21:56 GMT

Thanks a lot for your answer.
I couldn't do it. Can you add the formulas in the application ?