Using set analysis in "select in field" in actions

[#1]

I am trying to create an action for a button in which upon clicking, would select a list of UserNames belonging to Department A and Unit B.

Select in Field

={<Department='A', Unit='B'>} UserName

I've also tried

=Concat({<Department='A', Unit='B'>} UserName, '|')

I know it could be a quotation issues so I have also tried:

='={<Department='A', Unit='B'>} UserName'

='=Concat({<Department='A', Unit='B'>} UserName, '|')'

But none of these seem to be working.   Would be grateful if someone can let me know what is the correct way of writing this.

I am quite new to qlikview so would appreciate any help

Thank you so much!

[tresesco]

try like:

='(' & Concat({<Department={'A'}, Unit={'B'}>} Distinct UserName, '|') &')'

[tresesco · Accepted solution]

If the names have space in between, try like:

='(' & Concat({<Department={'A'}, Unit={'B'}>} Distinct '"'&UserName &'"', '|') &')'

'"' -> double quote(") with single quotes

[Kushal_Chawda]

try

='(' & Concat({<Department={'A'}, Unit={'B'}>} Distinct  chr(39) &UserName&chr(39) , '|') &')'

[#5]

Thanks this works!!!!

Could you briefly explain what & is doing in the expression?

I don't quite understand this.  Thank you so much