4 Replies Latest reply: Mar 28, 2011 6:58 AM by Vikas Singh RSS

    How to use nested query in qlik view reports.

    Vikas Singh

      I have the sql which have nested queries . I am not able to understand how to use nested query in the qlik view report.

      In my query temp table has been created and then the column of the temp table is used in where condition

       

       

       

      SELECT tmp.roster_cnt

       

      SELECT tmp.roster_cnt

      SELECT tmp.roster_cnt

       

       

      as total_count, w.territory_name FROM web_track_appts w

      (SELECT

       

      NVL(SUM(WI.ROSTER_CNT), 0) roster_cnt, territory_name

       

       



      FROM WEB_TRACK_APPTS WI

      (

       

      SELECT DISTINCT WRKEVNTID FROM WEB_TRACK_APPTS where appt_cnt is not null) temp

      where wi.wrkevnt=temp.wrkevnt group by territory_name) temp 1

      where w.territory_name=temp.territory_name

       

      Any suggestion how to proceed on this