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]
      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..!