4 Replies Latest reply: Apr 16, 2014 4:15 AM by Ashraf Muhammad Arsalan Ashraf RSS

    Alternative for Between clause (Urgent)

      Hi All,

      There is one time related Qvd which has a field calender date.

      I want to load this Qvd in my data model, but with condition that calendar date should be between 1/1/2013 to 10/4/2014.

      But qlikView doesn't allows the between clause for QVd reload.

       

      I have written the script like:

       

      Load  [Calender Date]
      FROM
      [Time_Dimension.qvd](
      qvd)
      Where [Calender Date] between '1/1/2013' and '10/4/2014';

       

      Can anybody help me to know what alternative I can use to write between for calendar date.

       

      Thanks in Advance..!