2 Replies Latest reply: Jan 9, 2013 8:29 AM by Tolgay Gul RSS

    subselect query

      Hi,

       

      Can we write subselect query in Qlikview? the example is below.

       

      select name,(select jobName from usersjob where usersjob.userid=users.id) as JobName from users

       

      Thanks,

        • Re: subselect query
          Gysbert Wassenaar

          If you use an sql select statement then that is send to the database as is. Qlikview doesn't process it, the dbms it is send to does. So you can do whatever you want in sql as long as your dbms supports it.

           

          The load statement can't do 'subselects'. The usual way is to use the exists function in a where clause or use the keep function. Here's a discussion with an example of both.