Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
shekhar_analyti
Specialist
Specialist

Set expression and Input box not working ? Help

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 .

set exp.PNG

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

Thanks & Regards

Shekar

1 Solution

Accepted Solutions
swuehl
MVP
MVP

4 Replies
swuehl
MVP
MVP

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

devarasu07
Master II
Master II

Hi,

Apostrophe causing the issue,

Escape sequences

chr( n ) function

shekhar_analyti
Specialist
Specialist
Author

Hi Stefan ,

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

Thanks & Regards

Shekar

swuehl
MVP
MVP