Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the alternative query for below one in qlikview.
SELECT ObjectID
FROM Location
WHERE HierarchyPath LIKE (
SELECT HierarchyPath
FROM Location
WHERE UserId= '123'
) + '%'
Example if HierarchyPath is 'C:\Users\Jino Kannen\' , then I should get the object Id of all paths under the given path.
HierarchyPath field Values are like below
C:\Users\Jino Kannen\Documents\
C:\Users\Jino Kannen\Documents\Qlik\
C:\Users\Jino Kannen\Documents\Qlik\Sense\Apps
C:\Users\Jino Kannen\Documents\Qlik\Sense\Extensions\MyfirstMashup
Thanks in advance!
Hi Jino,
Is your question for QlikView or Qlik Sense?
Maybe you can try: C:\Users\Jino Kannen\*, but I don't know if that would really work..
Jordy
Climber
yup..either QlikView/Sense. I need a generic solution.. not for this particular example.
Thanks Jordy for the quick response.