Alternative for Between clause (Urgent)

[#1]

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

[#2 · Accepted solution]

where [Calendar Date] >='1/1/2013' and [Calendar Date] <='10/4/2014'

[#3]

where [Calendar Date] >='1/1/2013' and [Calendar Date] <='10/4/2014'

[richard_pearce6]

Best to use brackets around the two where clauses

where ( [Calendar Date] >='1/1/2013' and [Calendar Date] <='10/4/2014' )

Richard

QlikCentral.Com

[arsal_90]

Load * from abc.qvd

where ( [Calendar Date] >='1/1/2013' and [Calendar Date] <='10/4/2014' );