Input box

[n1ef5ng1]

Is there ways user is able to select more than one options in input box?

my predefined list is from a particular field in the table.

file attached

[Sokkorn]

Hi Bennn,

Not sure if I understood you well. "Is there ways user is able to select more than one options in input box?" Does it mean that you want end user select more than one country? If answer is yes, why don't you use list box?

Here just an idea to move next.

1. Create new list box using Country field

2. Create new variable vCountry=Concat(DISTINCT Chr(39) & Country & Chr(39),',')

3.  Create Straight Table with

     a. Dimension: Country

     b. Expression: Sum({$<Country = {$(=vCountry)}>} Value)

See sample attached file

Regards,

Sokkorn

[n1ef5ng1]

Yeah i agree. but i am unable to use the country value as it kind of link the value from other table. is kinda hard to describle but is largely due to the design structure of the database. I 'merely' need the country list field to derivce a value that is unable to link from the country field. i hope you understand what I m talking about. By using input field, I can 'borrow' the field without any linkage of the country field from the other table

[Sokkorn]

HI Bennn,

Ok. What do you think if we use disconnect table in load script? Something like:

[tempCountry]:

LOAD * Inline [

tmpContryID,     tmpCountry

1,          cambodia

2,          viet nam

3,          thai

..................

];

Then we can use tmpContry in listbox and get those value for our set analysis.

Regards,

Sokkorn