topic Alternative for Between clause (Urgent) in QlikView

Alternative for Between clause (Urgent)

Wed, 16 Apr 2014 07:34:55 GMT

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

Wed, 16 Apr 2014 07:36:22 GMT

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

Wed, 16 Apr 2014 07:38:36 GMT

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

richard_pearce6 — Wed, 16 Apr 2014 08:09:41 GMT

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 — Wed, 16 Apr 2014 08:15:45 GMT

Load * from abc.qvd

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