topic Re: Set expression and Input box not working ? Help in QlikView

Set expression and Input box not working ? Help

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

I have to calculate sales for particular Item ( which has to be selected by user from Input box ) . But both are not working .

I tried same with sector , it worked for both Input box and set expression .

Thanks & Regards

Shekar

Re: Set expression and Input box not working ? Help

swuehl — Sat, 21 Oct 2017 10:04:31 GMT

I believe the single quote in your field values are corrupting your set modifier, because a pair of single quotes will indicate a literal. You can replace your single single quote with two single quotes to handle this

='Sales for Item ' & vItem & ' ' &

sum({<Item={$(=chr(39) & Replace(Replace(vItem,chr(39),chr(39)&chr(39)),';',chr(39)&','&chr(39))&chr(39))}>}sales)

The second Replace() is used to create a proper list of field mofidfier values, comma separated, while using semi-colon in your variable definition.

Escape sequences

Re: Set expression and Input box not working ? Help

devarasu07 — Sat, 21 Oct 2017 10:08:34 GMT

Hi,

Apostrophe causing the issue,

Escape sequences

chr( n ) function

Re: Set expression and Input box not working ? Help

shekhar_analyti — Sat, 21 Oct 2017 10:55:58 GMT

Hi Stefan ,

Thanks for the reply , but how to get this list of Items into Input box for user to select .

Thanks & Regards

Shekar

Re: Set expression and Input box not working ? Help

swuehl — Sat, 21 Oct 2017 11:02:17 GMT