topic Re: Proper Syntax for Field value through buttons that are text and numbers in QlikView

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

hhouston — Fri, 08 Dec 2023 18:08:28 GMT

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.

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

MatheusC — Fri, 08 Dec 2023 19:03:03 GMT

@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

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

rwunderlich — Fri, 08 Dec 2023 21:44:40 GMT

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

-Rob

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

hhouston — Mon, 11 Dec 2023 18:42:38 GMT

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.

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

rwunderlich — Mon, 11 Dec 2023 18:49:11 GMT

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)'

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

hhouston — Wed, 13 Dec 2023 19:54:12 GMT

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')"

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

hhouston — Thu, 14 Dec 2023 15:35:57 GMT