topic Re: List box selection, 1 selection, 2 fields in Current Selections Box in QlikView

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

Mon, 20 Oct 2014 14:14:26 GMT

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

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

alexandros17 — Mon, 20 Oct 2014 14:20:31 GMT

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

Let me know

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

martinpohl — Mon, 20 Oct 2014 14:20:33 GMT

create a new field in your employee table

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

and use it as the listbox

Regards

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

Mon, 20 Oct 2014 14:32:55 GMT

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.

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

alexandros17 — Mon, 20 Oct 2014 14:40:29 GMT

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

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

Mon, 20 Oct 2014 14:41:55 GMT

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

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

Mon, 20 Oct 2014 14:45:05 GMT

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.

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

Mon, 20 Oct 2014 15:35:59 GMT

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

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

stigchel — Mon, 20 Oct 2014 16:06:15 GMT

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