2 Replies Latest reply: Jan 3, 2017 10:32 AM by prabhu muthukrishnan RSS

    sql in function to qlikview scripting

    Prakash Dudala

      Hi

       

      I want to implement below query in qlikview scripting .

       

      SELECT

      *

      FROM

         DEPT

      WHERE

          DEPTNO  IN  (SELECT  DEPTNO FROM   DEPT WHERE  CLASS  =  'DESIGNATION')

       

      Scenerio: i already generated dept qvd .   so im having dept qvd.

       

      1st qvd ----select * from dept;

      2nd qvd : Now i want to create one more qvd based on below query . Please help to solve this.

       

      SELECT

      *

      FROM

         DEPT

      WHERE

          DEPTNO  IN  (SELECT  DEPTNO FROM   DEPT WHERE  CLASS  =  'DESIGNATION')

       

      Thanks

      Prakash