Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to select blank data?

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

8 Replies
fred_s
Partner - Creator III
Partner - Creator III

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

Miguel_Angel_Baeyens

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

Not applicable
Author

Hi,

Try this type of expression.

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

PrashantSangle

Hi,

Try like

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

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

awhitfield
Partner - Champion
Partner - Champion

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

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

awhitfield
Partner - Champion
Partner - Champion

OR try

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

Andy

ankitaag
Partner - Creator III
Partner - Creator III

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