More than one selection for possible values

[Anonymous]

Hi Team,

I have a company and brand fields in my table. I have a requirement where I will select a brand so that associated company will get automatically selected. So i have used a select field trigger on my brand field as 'only({<Company=P(Company)>}Company)'

But when I am doing this I am not able to select more than 1 brand. how can i select more than 1 brand keeping the functionality same. attached the qvw n sample data for better understanding. Please go to trigger tab to see brand field trigger.

Thanks

[lironbaram · Accepted solution]

hi

try this one

='(' & Concat({<Company=P(Company)>} distinct Company,'|') & ')'

[Anonymous]

Thanks Liron.

This really helps. using this I am able to drag and select multiple brands. but it is not allowing me to click and select multiple brands. in LED check box also it is not happening. it is possible only when I am doing a control select or drag select. please let me know if this is the way.