topic Re: Input box in QlikView

Input box

n1ef5ng1 — Wed, 18 Sep 2013 01:42:59 GMT

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

Re: Input box

Sokkorn — Wed, 18 Sep 2013 02:44:27 GMT

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

Re: Input box

n1ef5ng1 — Wed, 18 Sep 2013 02:49:41 GMT

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

Re: Input box

Sokkorn — Wed, 18 Sep 2013 03:18:49 GMT

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