topic How to search date range? in QlikView

How to search date range?

Tue, 30 Aug 2011 02:52:00 GMT

Hi All,

I have the following three fields: Year, Month, Date

I can use them to filter the data, but now I was wondering how to use search the range of the date, say I want to search 2010-10-01 to 2011-01-01,

how to achieve it? Any object supports it?

Thanks.

Tue, 30 Aug 2011 03:07:35 GMT

Check out the postings on Slider/Calendar objects.

Tue, 30 Aug 2011 03:10:57 GMT

But the date range is across two years, how to use calendar to handle it?

Tue, 27 Mar 2012 02:05:41 GMT

use

LOAD Year,

Month,

Date,

date#(Year&Month&Date,'YYYYMMDD') as newfieldname

FROM

[1.xls]

(biff, embedded labels, table is Sheet1$);

in the script.

create Calendar objects or list box.