3 Replies Latest reply: Jun 18, 2013 7:57 AM by shehan Chaturanga RSS

    Sql query get to the qlikview

      hi im shehan

      How to write this query using qlikview .i need create a table using this query

       

      select distinct nawinna_inltran.inlddt,wekmast.wekwek From nawinna_inltran,wekmast

      where   nawinna_inltran.inlddt>=wekmast.wekfrddt  and   nawinna_inltran.inlddt<=wekmast.wektoddt and to_char(nawinna_inltran.inlddt,'YYYY-MM') ='2013-05';

       

      plz help me on that

        • Re: Sql query get to the qlikview
          Vishwaranjan Kumar

          According to your query we wirite the code in qlikview

          TableA:

          load * ;

          Sql select inlddt  from   nawinna_inltran;

           

          TableB:

          load *;

          Sql select wekwek, wekfrddt, wektoddt  from  wekmast;

           

          DataTable:

          load *, rowno() as Key  resident TableA;

           

          join

           

          load * ,rowno() as Key  resident TableB;

           

          Output:

          load *  resident DataTable

          where  inlddt>=wekfrddt   and   inlddt<=wektoddt    and   inlddt ='2013-05';

           

           

          note -- set all the date in this format like

          date(inlddt,'YYYY-MM')  AS  inlddt,

          date(wekfrddt ,'YYYY-MM' ) AS wekfrddt,

          date(wektoddt,'YYYY-MM') AS wektoddt