Join and like function on same table

[jino_kannen]

Spoiler

Is it possible to do same sql query on qlik?
SELECT distinct(L.ObjectID)
FROM Location L join Location LL on
L.HierarchyPath like concat(LL.HierarchyPath ,"%") 

[jino_kannen]

If a Hierarchy path is selected , all its succeeding paths have to be listed.
paths are like

08m9FMK+YkGfdZVOuDn5JQ==.
08m9FMK+YkGfdZVOuDn5JQ==.fTOIO216FEysydjZ+hXPCA==.
08m9FMK+YkGfdZVOuDn5JQ==.fTOIO216FEysydjZ+hXPCA==.CXZbHjLTMkeYzNhM7SjQCA==

[Channa]

yes u can write sql

or u can build view and call the view