List box selection, 1 selection, 2 fields in Current Selections Box

[#1]

Howdy,

I am using a formula to only show certain employees in a list box.

If(EmployeeType = 'Sales',Employee,null())

When i click on an employee in the list box, it's showing two selections.

1) The employee i selected

2) the EmployeeType Sales selection

How can i limit a list boxes selections, while not having two columns show up in the current selections box?

-David

[alexandros17]

Delete your expression and copy it in the expression at the end of fields' list ...

Let me know

[martinpohl]

create a new field in your employee table

If(EmployeeType = 'Sales',Employee,null()) as Salesemployee

and use it as the listbox

Regards

[#4]

Thank you for the response!

I'm not quite sure i understand...I know i can do this in script, but was hoping to do within the dashboard for script simplicity.

[alexandros17]

Right click your list box, in tab General, open Fields, at the end you find a voice "Expression", select it and copy your actual expression (Delete it from the second tab)

let me kow

[#6]

Thank you for the response! I'm trying to do it in the dashboard, if possible for script simplicity

[#7]

Ahh, now I understand.

That is actually what i'm using right now. Just using the expression as the field. I'm not using the expressions tab, currently.

[#8]

Couldn't figure out how to do this in the dashboard, just used applymap() to add the employee type to my fact table.

[stigchel]

I think you can manage by moving the if Field = statement to a set analysis, for that you would need a function that takes set analysis, something like

Aggr(Concat({<EmployeeType='Sales'>} DISTINCT Employee),Employee)

As expression in your listbox