topic Re: Join and Like on same table in QlikView

Join and Like on same table

jino_kannen — Sun, 17 Mar 2019 12:38:04 GMT

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==

Re: Join and Like on same table

Gysbert_Wassenaar — Sun, 17 Mar 2019 17:24:21 GMT

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

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

Re: Join and Like on same table

jino_kannen — Wed, 20 Mar 2019 08:49:25 GMT

My actual question is somewhat similar to below query.

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Help-with-Hierarchy-Path-and-Populating-the-broken-out-fields/td-p/1186058

Re: Join and Like on same table

Gysbert_Wassenaar — Wed, 20 Mar 2019 10:35:40 GMT

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

Re: Join and Like on same table

jino_kannen — Sun, 24 Mar 2019 12:04:20 GMT

Yup. Thank you!! It works well.