topic Input Box with pre defined listed values - formula instead of written list in QlikView

Input Box with pre defined listed values - formula instead of written list

Wed, 23 Mar 2011 15:59:00 GMT

Hi,

I have an input box that works fine with a predifined list of values typed in e.g.

;Very Easy;Somewhat Easy;Undecided;Somewhat Difficult;Very Difficult

However im trying to add a forumla that has these predifined values stored in a field called 'Answer Options'. The formula picks up the values correctly which but doesnt make them appear as a list. My formula is:

=ONLY({1<[Question Number]={"1"}>}[Answer Options])

Any help?

Input Box with pre defined listed values - formula instead of written list

Oleg_Troyansky — Wed, 23 Mar 2011 16:11:48 GMT

Hi,

function Only() can't be used for multiple values - it can only return a single available value. The syntax for your case is this:

=concat({1<[Question Number]={"1"}>} [Answer Options], ',')

You may wonder why do we use a coma instead of a semi-colon (I'm wondering, too), but this is the way it works - the list is presented correctly with the coma, and incorrectly with semi-colon, for some reason...

cheers,

Input Box with pre defined listed values - formula instead of written list

Wed, 23 Mar 2011 16:28:22 GMT

Hi Oleg,

Thanks for your help. But the list still comes up as 1 value.

Perhaps a look at the data sheet that feeds the field 'Answer Options' explains how my data is organised. Im trying to use the box in red from the formula.

Any ideas?

Input Box with pre defined listed values - formula instead of written list

Oleg_Troyansky — Wed, 23 Mar 2011 16:35:02 GMT

try replacing semi-colons with commas and see if it works

Input Box with pre defined listed values - formula instead of written list

Wed, 23 Mar 2011 16:39:35 GMT

hi oleg excellent advise

many thanks

Input Box with pre defined listed values - formula instead of written list

Oleg_Troyansky — Wed, 23 Mar 2011 16:44:07 GMT

let me take back what I said before about only() - in your case, you already combined multiple values into a single field, so the use of only() was totally appropriate...

I just tested the list with commas, and it works just fine. See attached