Filter nulls/non nulls on List Box

[amigo007]

I have a table on my dashboard in a similar format as follow:

ID	Name	Country	Account Number
1	Name1	Country1	1111
2	Name2	Country2	-
3	Name3	Country3	-
4	Name4	Country4	2222
5	Name5	Country5	-

I need to add a filter/flag on my dashboard in a list box for 'Account Number' field. The header for the list box is something like 'Account Number null?', then the list box would have two selections: 'Yes' and 'No'. So selecting 'Yes' will show only rows with IDs 2, 3 and 5 while 'No' will return the table with rows 1 and 4.

Thanks in advance.

[tresesco]

Is this a table box or straight table?

[amigo007]

Table box.

[Anil_Babu_Samineni]

May be this in script?

LOAD ID,

     Name,

     Country,

     [Account Number],

     If([Account Number]='-', 'Yes', 'No') as NullFlag

FROM

[https://community.qlik.com/message/1262813]

(html, codepage is 1252, embedded labels, table is @1);

[amigo007]

Thanks.

Is there a way to add the flag directly on the dashboard rather from the loading script?

I'm loading my data from SQL server.

[trdandamudi]

Create a list box and in the expression use the below code :

=If(Left([Account Number],1)='-','Yes','No')

[Anil_Babu_Samineni]

NP, Just add one line script after generating the code.

Connection string of SQL Server

Load *,

If([Account Number]='-', 'Yes', 'No') as NullFlag

From <Data Source od SQL Server>;

[tresesco]

Try using straight table like in attached sample.

[amigo007]

Thanks.

I'm having a big table box with a lot of data, so a solution that could work with a table box will be highly appreciated.

Also, for the list box, is there a possibility to have 'Yes' and 'No' as a check boxes? i.e. It will be allowed also to display the table with all the data (if 'Yes' and 'No' are not checked).

[amigo007]

Actually the values are null and not '-'. I guess QlikView displays nulls as '-' in tables.

Will a similar syntax as SQL work here as well? i.e. If([Account Number]) is NULL...