topic Re: How to select blank data? in QlikView

How to select blank data?

Sun, 15 Mar 2015 10:42:11 GMT

Hi, last time I asked the question : how to select data when for example I want only the YES data.

ex :

count({<[REACH Rem]={'Y'}>}[REACH Rem])

How do I do the same request but with blank data (= nothing in the cell?) I tried {' '} but it does not work.

Thanks in advance

Re: How to select blank data?

fred_s — Sun, 15 Mar 2015 11:05:06 GMT

Hi Aurelie,

You could start with

count({<[REACH Rem]={''}>}[REACH Rem])

Thats '' instead of ' ' (no space).

Otherwise it's gonna be counting and selecting so called null() values and to be honest, I have to check how (and if) it works.

Grtz. Fred

Re: How to select blank data?

Miguel_Angel_Baeyens — Sun, 15 Mar 2015 11:15:26 GMT

Hi Aurélie,

That "blank data" is actual data or null values as a result of an aggregation where no values were provided?

In the first case, I'd better use any other character to replace blanks or spaces and avoid confusion, in the second, you should need how null those null values are to be able to select them (basically, following the whitepaper and explanation here: Finding NULL)

Miguel

Re: How to select blank data?

Mon, 16 Mar 2015 07:33:08 GMT

Hi,

Try this type of expression.

=if([REACH Rem]<0,[REACH Rem])

Re: How to select blank data?

PrashantSangle — Mon, 16 Mar 2015 07:41:59 GMT

Hi,

Try like

count({<[REACH Rem]={"=isnull([REACH REM])"}>}[REACH Rem])

Regards,

Re: How to select blank data?

Mon, 16 Mar 2015 07:43:21 GMT

Hi,

You may try

if( isnull( [REACH Rem])=-1,'BLANK',[REACH Rem])) as Dimension.

most probably blank data is not selected in dimension of any chart.

Regards

Vimlesh

Re: How to select blank data?

awhitfield — Mon, 16 Mar 2015 10:27:25 GMT

Dependant upon whether the value is actually NULL OR MISSING, you could use

NullCount([REACH Rem]) OR MissingCount([REACH Rem])

Re: How to select blank data?

awhitfield — Mon, 16 Mar 2015 10:42:00 GMT

OR try

=Count({$-<[REACH Rem]={'?*'}>}REACH Rem)

Andy

Re: How to select blank data?

ankitaag — Mon, 16 Mar 2015 13:09:33 GMT

Hello Aurelie,

The expression to select the blank data is

=count({<[REACH Rem]={''}>}[REACH Rem])

That's '' instead of ' '.

' ' has one space and '' is actually a blank value.

count of ' ' is trying to find values consisting of 1 space which is not present in your data.

count of '' will give you the correct result.

Thanks and Regards,

Ankita