List box selection

[#1]

Hi I have a field

Field

a

b

c

d

e

f

now the requirement is to make a list box which will contain just a b c and if we select any of the a b or c ,d,e,f should always be selected.

In other words d,e,f should always be selected and give the user the option only to select from a,b,c (if we do not show d,e,f in the list box its a bonus)

Any thoughts on how to accomplish this

[Anonymous]

Hey,

there are many ways.

If the listbox values are static, you may create additional column in script using if statement(if (match(col1,'a','b','c'),col1)). use this column for list box.

or

if your values is dynamic and falling under certain scenario, you can use that condition to pick only those values into additoinal column and make use it for your list box.

or

If you really don't need these rows you can restrict them in dimension table it self in query using where clause.

Hope this helps.

Regards,

Chinna.

[#3]

i would suggest to create filtering data in script

something like following should help see attached example:

OrigTable:

Load *

Inline [

  Field, Group

  a, 1

  b, 1

  c, 1

  d, 2

  e, 2

  f, 2

];

/* get good field values filtering themselves  */

NewTable:

LOAD Field as ParentField,

     Field // child field to filter, links to existing data model

Resident OrigTable

Where Group = 1;

/* now produce all combinations (cartasian) of group 1 and 2 */

tmpTable:

LOAD Field as ParentField

Resident OrigTable

Where Group = 1;

Join(tmpTable)

LOAD Field

Resident OrigTable

Where Group = 2;

Concatenate(NewTable)

LOAD * Resident tmpTable;

DROP Table tmpTable;

[#4]

the problem with this is, if i choose a then d,e,f do not get selected only a gets selected, my requirement is if  a is selected then a,d,e,f should get selected or if b is selected then b,d,e,f is selected

[#5]

Hi,

You can create field event trigger (OnChange) on this ParentField and make further selections on Field value itself