Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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...
Example attached.
Unfortunately selection remains in the same position.
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.
How to:
Note: you can uncomment the msgbox lines to use for testing.
Code:
sub AccountPathRefresh
'msgbox "start"
set vObject = ActiveDocument.GetSheetObject("LB02")
set vChange=vObject.GetProperties
vChange.Layout.ShowAsTreeView = false
vObject.setproperties vChange
vChange.Layout.ShowAsTreeView = true
vObject.setproperties vChange
'msgbox "finished"
end sub
Do do Left join and keep the Path field in another table.
I am not sure the delimiter is '-' not '~'
In the List box Try with '-' as delimiter
Hi dathu:
I'm interested in your solution to the sorting on the tree, can you explain some more.
Gerry