3 Replies Latest reply: Nov 17, 2014 8:23 PM by Seiko Fujiwara RSS

    How can I convert a SQL to QV Script?

      Hello.

       

      Now I'm working for a project to convert an application built in MS Excel to QlikView.

      I understand these two are based on different concepts, however, because the result of the applicaiton should be the same, some codes are needed to be converted simply...

       

      What I'm in stuck is this.

      There are two qvd files and I want to manage this function in qv script.

      -----------------------------------------------------

      SELECT *

      FROM QVD1, QVD2

      WHERE QVD1.CD = QVD2.CD

      AND QVD1.DATE >= QVD2.RANGE_FROM

      AND QVD1.DATE < QVD2.RANGE_TO

      -----------------------------------------------------

       

      QVD1. CD nor QVD2. CD are not.

       

      Does any body have any ideas or solution?

       

      Thank you very much.

       

      Regards,