topic Re: Re: Is it possible to make selections for blank values in list box? in QlikView

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

Wed, 11 Jun 2014 10:38:55 GMT

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.

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

hic — Wed, 11 Jun 2014 10:42:21 GMT

If they are visible in a list box, it should be possible. NULLs are however not visible.

But blanks in a straight table column? Is it a measure or a dimension?

HIC

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

shane_spencer — Wed, 11 Jun 2014 10:55:14 GMT

Could you select all the options, AA, BB, CC etc then "select excluded" to get the blanks?

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

jsingh71 — Wed, 11 Jun 2014 11:01:44 GMT

Yes we can make the selection.

For example find attachment.

--Jai

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

Wed, 11 Jun 2014 11:19:16 GMT

Thanks. I tried but it seems not working the expected result. I want the list box to show AA,BB, CC and blanks. Is it possible? Please help.

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

Wed, 11 Jun 2014 11:19:58 GMT

Thanks. It is dimension. I want the NUlls to show in list box. Is it possible?

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

Wed, 11 Jun 2014 11:20:22 GMT

Thanks. where can I see the 'select excluded'?

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

jsingh71 — Wed, 11 Jun 2014 11:21:22 GMT

I already shared example. If you want anything specific then please attach sample app.

--jai

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

Wed, 11 Jun 2014 11:30:22 GMT

Please see attached.

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

jsingh71 — Wed, 11 Jun 2014 11:45:02 GMT

Hi Please find updated qvw file.

--Jai

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

jagannalla — Wed, 11 Jun 2014 11:59:57 GMT

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

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

Wed, 11 Jun 2014 12:33:01 GMT

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

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

Wed, 11 Jun 2014 15:29:10 GMT

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

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

Peter_Cammaert — Wed, 11 Jun 2014 15:40:26 GMT

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.

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

Peter_Cammaert — Wed, 11 Jun 2014 15:46:13 GMT

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.

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

Wed, 11 Jun 2014 16:01:40 GMT

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

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

MK_QSL — Wed, 11 Jun 2014 16:10:55 GMT

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,

Inline

[

Status, ID

AA, 3

BB, 2

CC, 1

-, 10

];

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

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

Thu, 12 Jun 2014 04:03:06 GMT

you can add expression in listbox like below:

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

PFA

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

hic — Thu, 12 Jun 2014 07:10:55 GMT

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

HIC

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

Thu, 12 Jun 2014 14:06:49 GMT

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?