Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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==
Yup. Thank you!! It works well.
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
My actual question is somewhat similar to below query.
Yup. Thank you!! It works well.