Join and Like on same table

[jino_kannen]

Is it possible to replicate below similar queries in Qlik?

SELECT distinct(L.ObjectID)
FROM Location L
join Location LL
on
L.HierarchyPath like concat(LL.HierarchyPath ,"%")
and LL.HierarchyPath = '08m9FMK+YkGfdZVOuDn5JQ==.'

example of Values of  field 'HierarchyPath' is like below, wanted to list all object ids of succeeding Hierarchy paths under a given Hierarchy Path

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

[Gysbert_Wassenaar]

Qlik you'd use the Hierarchy prefix for that: http://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefi...

See this blog post for more information and examples: https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

[jino_kannen]

My actual question is somewhat similar to below query.

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Help-with-Hierarchy-Path-and-Populating...

[Gysbert_Wassenaar]

Perhaps you want to use HierarchyBelongsTo prefix then as explained in the blog post I referred to above.

[jino_kannen · Accepted solution]

Yup. Thank you!! It works well.