topic Can we select Multiple values in a List box & make the corresponding values reflect in Text boxes in QlikView

Can we select Multiple values in a List box & make the corresponding values reflect in Text boxes

rammarthi — Tue, 23 Jan 2018 14:25:07 GMT

Hi,

Can we select Multiple values in a List box & make the corresponding values reflect in Text Box/Boxes

I have a month field and corresponding value field. If I select multiple months, mulitiple values seperated by comma's without month names should be popping in a text box is it possible. I tried with another list box but I want without monthnames and unwanted zeros.

Thanks in advance.

Regards

Ram

Re: Can we select Multiple values in a List box & make the corresponding values reflect in Text boxes

sunny_talwar — Tue, 23 Jan 2018 14:38:15 GMT

I think it should be possible... in above case, you would want to see 20, 10, 80, 90, 40 in a text box object?

Re: Can we select Multiple values in a List box & make the corresponding values reflect in Text boxes

rammarthi — Tue, 23 Jan 2018 16:28:37 GMT

Yes absolutely!!!

Re: Can we select Multiple values in a List box & make the corresponding values reflect in Text boxes

sunny_talwar — Wed, 24 Jan 2018 10:11:00 GMT

Just use =Concat(DISTINCT Value, ', ') in a text box object.