topic Re: More than one selection for possible values in QlikView

More than one selection for possible values

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: More than one selection for possible values

lironbaram — Mon, 06 Mar 2017 07:48:59 GMT

try this one

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

Re: More than one selection for possible values

Anonymous — Mon, 06 Mar 2017 09:32:16 GMT

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.