Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

23 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

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

Not applicable
Author

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......

Not applicable
Author

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

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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.

Not applicable
Author

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

MK_QSL
MVP
MVP

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

];

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

Not applicable
Author

you can add expression in listbox like below:

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

PFA

hic
Former Employee
Former Employee

Not applicable
Author

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?