Is it possible to make selections for blank values in list box?

[#1]

Hi,

Is there any way to make selections on blanks in list box. As I have one column in straight table which have values

Status= AA, BB,CC and  blanks

could anyone suggest me will it possible?

Thanks.

[jagannalla]

Hi,

- If you want see null in listbox just use this code infront of load statement.

NULLASVALUE Status;

Data:

LOAD Id,

    Status

FROM

[D ST.xlsx]

(ooxml, embedded labels, table is Sheet1);

- If you want to display any null symbol in listbox then use below code.

set NullInterpret='-';

NULLASVALUE Status;

Data:

LOAD Id,

    Status

FROM

[D ST.xlsx]

(ooxml, embedded labels, table is Sheet1);

Please find the attachment.

Hope it helps you.

Cheers!!
Jagan

[#3]

Hi,

add the following line into your script:

if(isnull(Status),'-',Status) as Status

like the following:

LOAD Id,

     Status as dump,

     if(isnull(Status),'-',Status) as Status

Hope it will help......

[#4]

Thanks. I tried both but no change in list box. Please help me to sort this.

[Peter_Cammaert]

Select all values in a list box

Right-click the list box, and from the menu, choose "Select excluded"

Even if it seems that you deselected everything in the list box, various rows in other tables with a NULL value have been selected now.

[Peter_Cammaert]

The idea is simple tho: if you want to be able to discern between valid and invalid (e.g. NULL) values in a field, replace the NULL values in every LOAD statement with something that flashes red, like the string '*UNDEFINED*' or the minus sign that Saranya suggested. See the test for NULL values in field Status below.

[#7]

Thanks I used this but no change. Do I need to chaage anything ?

[MK_QSL]

This is just an example, change accordingly...

========================

Temp:

Load

  If(LEN(TRIM(Status))=0,Null(), Status) as Status,

  IF(Len(Trim(Replace(Status,'-','')))=0,'NO STATUS', Status) as Status2,

  ID

Inline

[

  Status, ID

  AA, 3

  BB, 2

  CC, 1

  -, 10

];

================

[#9]

you can add expression in listbox like below:

=if(isnull(Status) and Id<>'','-',Status)

PFA

[hic]

Also, take a look at http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/02/finding-null

HIC

[#11]

Thanks. I can able to get the blank in list box. when I am selecting the blank in list box the data is not changing corresponding to the blank selection. Am I missing anything?