topic Re: Suppress quotation marks in Variable Input and SimpleFieldSelect for dimensions with space in name in App Development

Suppress quotation marks in Variable Input and SimpleFieldSelect for dimensions with space in name

Greg_Oliven — Mon, 20 Dec 2021 21:02:46 GMT

I am using a variable to place a selected dimension in a pivot chart. I am trying both Variable Input and SimpleFieldSelect, but when there is a space in the name of the dimension, both extensions show the dimension name with quotation marks in the pivot.

Variable Input solves half the problem with its alias - but this only solves it in its own interface, not in the pivot chart:

Re: Suppress quotation marks in Variable Input and SimpleFieldSelect for dimensions with space in name

Or — Mon, 15 Mar 2021 13:58:43 GMT

I haven't really worked with either variable inputs for this, but... why not strip the offending characters in your pivot table formula instead of trying to strip them from the input box? I believe you'd want PurgeChar(vMyVariable,'"') (that's two single quotes around a double quote)

Re: Suppress quotation marks in Variable Input and SimpleFieldSelect for dimensions with space in name

Greg_Oliven — Mon, 15 Mar 2021 14:46:29 GMT

Thanks - that works great for the dimension label for either extension.

Since my post, I decided to go with SimpleFieldSelect due to the better formatting it provides on a horizontal list - so now I just need to figure out how to remove the quotes from its list items - i.e. where "ARM or FRM" is highlighted in green in the image I posted.

Re: Suppress quotation marks in Variable Input and SimpleFieldSelect for dimensions with space in name

Or — Mon, 15 Mar 2021 14:49:13 GMT

Is this a cosmetic issue where you just don't want them displayed, or is this causing you actual problems with your formulas / objects? The latter may be something to easily work around, but the former would be specific to the extension / variable input object in question so not something I can help with unfortunately.

Re: Suppress quotation marks in Variable Input and SimpleFieldSelect for dimensions with space in name

Greg_Oliven — Mon, 15 Mar 2021 15:10:15 GMT

Thanks - yes, it is just the former (cosmetic) - thank-you for your help on the label side of the question.

Re: Suppress quotation marks in Variable Input and SimpleFieldSelect for dimensions with space in name

Greg_Oliven — Tue, 16 Mar 2021 15:03:45 GMT

The author of SimpleFieldSelect just released version 2.0.8 (https://github.com/mediassarQlikBranch/SimpleFieldSelect) with the needed option:

A big thank-you to the team at Oivalo Oy.