3 Replies Latest reply: Dec 19, 2014 4:06 PM by Anand Chouhan RSS

    creating variable  for a condition in SQL querry to load data

    saurabh singh


      hi all,

      i want to load some data in Qlikview and create a qvd for the same.

       

      i have the following query

       

      SQL Select   *

      from  xyz.FACT, xyz.DIR

      WHERE FACT.STARTING_DATE <= DIR.DATE_REC

             AND FACT.ENDING_DATE > DIR.DATE_REC

             AND FACT.FLG='N'  AND

      FACT.TESTER ='PERF';

       

       

       

      But i want to create variable for the condition (FACT.STARTING_DATE <= DIR.DATE_REC

        AND FACT.ENDING_DATE > DIR.DATE_REC)    so  that i pick only the max value from the database

       

       

      thanks in advance!!