Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
If the names have space in between, try like:
='(' & Concat({<Department={'A'}, Unit={'B'}>} Distinct '"'&UserName &'"', '|') &')'
'"' -> double quote(") with single quotes
try like:
='(' & Concat({<Department={'A'}, Unit={'B'}>} Distinct UserName, '|') &')'
If the names have space in between, try like:
='(' & Concat({<Department={'A'}, Unit={'B'}>} Distinct '"'&UserName &'"', '|') &')'
'"' -> double quote(") with single quotes
try
='(' & Concat({<Department={'A'}, Unit={'B'}>} Distinct chr(39) &UserName&chr(39) , '|') &')'
Thanks this works!!!!
Could you briefly explain what & is doing in the expression?
I don't quite understand this. Thank you so much