2 Replies Latest reply: Jun 23, 2016 3:14 PM by Siddharth Sharma RSS

    External data that I want to read has a date column, I want rows where date is Yesterday date, all rows that have last week date, all rows that have last month date..how to do it in Qlikview script? please note, my database is in SQL server

    Siddharth Sharma

      external data that I want to read has a date column, I want rows where date is Yesterday date, all rows that have last week date, all rows that have last month date..how to do it in Qlikview script? please note, my database is in SQL server

       

      Need help asap

       

      Thanks in Advance

       

      my script is

      OLEDB Connect to [provider=SQLOLEDB.1.................................................]

       

      SQL SELECT *

      FROM 'abc.DBO.'XYZ' ;