Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
n1ef5ng1
Creator
Creator

I believe it is a bug...

I believe this is a bug.

Please see attached.

For some reason, my report does need an input box with those fields from a attribute from a table(Country)

Therefore there is few countries in these example, Singapore, Malaysia etc. when user select malaysia, it will show the value of the output.

However for countries that has a space like VIET NAM or UNITED STATES, it does not read.

what it the reason behind it.

clueless

1 Solution

Accepted Solutions
tresesco
MVP
MVP

No it's not a bug. You have to use quotes in set. PFA.

Expression: =sum({$<Country ={'$(=(var_Country))'}>} Value)

View solution in original post

4 Replies
tresesco
MVP
MVP

No it's not a bug. You have to use quotes in set. PFA.

Expression: =sum({$<Country ={'$(=(var_Country))'}>} Value)

n1ef5ng1
Creator
Creator
Author

Thanks!!!!

Anonymous
Not applicable

Hi,

QlikView input box does not have problem capturing string with space, the reason for your table not showing result when a string with spaces has been entered to the input box is that you need to use double quotes to wrap your content in the set analysis when there is spaces in your content. Your expression should look like :

=sum({$<Country ={"$(=(var_Country))"}>} Value)

Regards.

n1ef5ng1
Creator
Creator
Author

I have a question. is there any where user can select two options from the input box that I have.

say if user select malaysia n united states, it will show the computation value.