topic Re: selecting from listboxes in QlikView

selecting from listboxes

rdsuperlike — Fri, 03 Feb 2017 18:07:20 GMT

I have 5 list box,

Office Head,

Dept head,

VP name,

Org head

Location Head.

I want to show name in a text box based on the selected listbox.

For eg: if user choose Dept head text box should show that, if user chooses Org head text box should show that and so on.

Peter_Cammaert — Fri, 03 Feb 2017 18:18:40 GMT

What should be shown if a user makes selections in multiple list boxes?

rdsuperlike — Fri, 03 Feb 2017 18:21:23 GMT

User will not select multiple listbox at same time. But basically the the list that is selected only that value/values should appear in textbox

Peter_Cammaert — Fri, 03 Feb 2017 18:46:07 GMT

You can try with a Text Box expression like this:

= IF (GetSelectedCount([Office Head]) > 0, 'Office Head',

IF (GetSelectedCount([Dept head]) > 0, 'Dept head',

IF (GetSelectedCount([VP name]) > 0, 'VP name',

IF (GetSelectedCount([Org head]) > 0, 'Org head',

IF (GetSelectedCount([Location Head]) > 0, 'Location Head', 'None')))))

Best,

Peter

MarcoWedel — Sat, 04 Feb 2017 00:00:16 GMT

Hi,

maybe one solution could be:

SubField(GetCurrentSelections(),':',1)

hope this helps

regards

Marco