Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

selecting from listboxes

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.

4 Replies
Highlighted

Re: selecting from listboxes

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

Highlighted
Contributor

Re: selecting from listboxes

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

Highlighted

Re: selecting from listboxes

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

Highlighted

Re: selecting from listboxes

Hi,

maybe one solution could be:

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

QlikCommunity_Thread_248682_Pic2.JPG

QlikCommunity_Thread_248682_Pic3.JPG

hope this helps

regards

Marco