Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
rdsuperlike
Creator
Creator

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
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

rdsuperlike
Creator
Creator
Author

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
Partner - Champion III
Partner - Champion III

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

Hi,

maybe one solution could be:

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

QlikCommunity_Thread_248682_Pic2.JPG

QlikCommunity_Thread_248682_Pic3.JPG

hope this helps

regards

Marco