Always show list box

[#1]

I have a list box with "Windows Checkboxes" as selection style.

This list box has an expression defined like below:

=if([Has-license-car]=1,'Has license car')

Field [Has-license-car] is a bit type (0 or 1) that is loaded from a SQL table:

ID	Category	Has-license-car
1	Analyst	1
2	Director	1
3	Manager	0
4	Analyst	0
5	Comercial	1

When I check the list box this only shows personal that has license car. Otherwise it shows all the personal.

The problem here is when I have a table like below in which all "Has-license-car" values are 0:

ID	Category	Has-license-car
1	Analyst	0
2	Director	0
3	Manager	0
4	Analyst	0
5	Comercial	0

In this case since all "Has-license-car" values are 0 then list box is never shown.

So what I am trying to do is to always show the list box even if all "Has-license-car" values are 0.

[rahulpawarb]

Hello Tony,

Trust that you are doing good!

You can make use of Data Island to solve your query. Create data island table using below load script and post that you can use Has-license-car field in List box.

MyIsland:

LOAD * INLINE [

Metric, Has-license-car

Has-license-car, 1

];

Hope this will be helpful.

Regards!

Rahul