Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
No it's not a bug. You have to use quotes in set. PFA.
Expression: =sum({$<Country ={'$(=(var_Country))'}>} Value)
No it's not a bug. You have to use quotes in set. PFA.
Expression: =sum({$<Country ={'$(=(var_Country))'}>} Value)
Thanks!!!!
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.
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.