Sub query with like function in qlikview as in SQL

[jino_kannen]

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!

[JordyWegman]

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

[jino_kannen]

yup..either QlikView/Sense. I need a generic solution.. not for this particular example.

Thanks Jordy for the quick response.