Discussion Board for collaboration related to QlikView App Development.
I have 5 list box,
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.
What should be shown if a user makes selections in multiple list boxes?
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
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')))))
maybe one solution could be:
hope this helps