Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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......
Thanks. I tried both but no change in list box. Please help me to sort this.
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.
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.
Thanks I used this but no change. Do I need to chaage anything ?
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
];
================
you can add expression in listbox like below:
=if(isnull(Status) and Id<>'','-',Status)
PFA
Also, take a look at http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/02/finding-null
HIC
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?