I have listbox setup as treeview to represent customer structure. Qlikview display the hierarchy properly, but if you try to search, selection wil not rise to the top of the list eventhough the sort is set to state: Auto ascending . You have no choice but to scroll down to the original location of the value. As list contains over 40K values this becomes a problem...
I use a Macro to fix this issue. I do have one list box working perfectly but another doesn't so I cant promiss it will be 100%. I am currently trying to make this bullet proof but hopefully it should be fine for your purpose.
Add a text box. e.g. "Update account list"
Click on actions tab and add a "External" -> "Run Macro"
Call the Macro something and then press edit module. e.g. "AccountPathRefresh"
Copy the below into the module and update the sub ************* to be the same as the module to be the same as the one your text will call when it is pressed.
Update the getsheetobject("****") to be the object name of your list box.
Note: you can uncomment the msgbox lines to use for testing.
set vObject = ActiveDocument.GetSheetObject("LB02")