Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

Highlighted
Creator
Creator

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

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

Hi,

maybe one solution could be:

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

QlikCommunity_Thread_248682_Pic2.JPG

QlikCommunity_Thread_248682_Pic3.JPG

hope this helps

regards

Marco