Proper Syntax for Field value through buttons that are text and numbers

[hhouston]

Hello, 

I currently have a button that I have actions set up against it. 

In the Action button I have a field that is selected. 

Inside of the Expression editor in the field, I am trying to pull these values:

"(6010015 - Penguin Random House LLC|6010030 - HarperCollins Publishers|6010031 - Macmillan Publishing USA|6010033 - Hachette Book Group USA|6010036 - Simon Schuster)"

What is the proper syntax for using text/numbers? I used this before: "(6010030|6010033|6010015|6010031|6010036)" and this worked perfect. 

Any help will is appreciated. 

[MatheusC]

@hhouston 

Although I'm not familiar with Qlik view, I believe this post can help you.

https://community.qlik.com/t5/Brasil/Bot%C3%A3o-para-selecionar-campo/td-p/1675859

Maybe in the concat you need to add the quotation marks ' or "" because it has a textual set, something like:
='("'&Concat(Field, '"|"')&'")'

I hope it helps

Att, 
Matheus

[rwunderlich]

I think it's double quotes around each value. You can test by entering the () expression in a listbox search.

-Rob

[hhouston]

Thanks. I tried both, recommendations, but still running into the same behavior.

Here is what I am trying to use  ='(6010015 - Penguin Random House LLC|6010030 - HarperCollins Publishers|6010031 - Macmillan Publishing USA|6010033 - Hachette Book Group USA|6010036 - Simon Schuster)'

I used"(6010030|6010033|6010015|6010031|6010036)" before and that worked just fine since these are numbers only I believe.

[rwunderlich]

I meant quoting each individual value with single or double quotes like:

('6010015 - Penguin Random House LLC'|"6010030 - HarperCollins Publishers"|6010031 - Macmillan Publishing USA|6010033 - Hachette Book Group USA|6010036 - Simon Schuster)'

[hhouston]

Thanks. I tried both those methods but no luck. 

Here is the full syntax that I am trying to use for example: ="('6010015 - Penguin Random House LLC')"

[hhouston · Accepted solution]

Was able to figure it out. ='("6010015 - Penguin Random House LLC"|"6010030 - HarperCollins Publishers"|"6010031 - Macmillan Publishing USA"|"6010033 - Hachette Book Group USA"|"6010036 - Simon Schuster"|"6028556 - Springer Nature B V"|"6037352 - Bloomsbury Publishing plc"|"6047714 - Sounds True Inc"|"6079060 - Pan Macmillan"|"6108851 - Page Two Books inc")'