topic Re: Date Range Selection in QlikView

Date Range Selection

techvarun — Mon, 26 Aug 2013 11:22:42 GMT

I have a SQL table with more than 13 lakh records, I qureried all the records and stored in in a QVD for fast access now i need to show the Data's between two particular date Ranges...

How to fetch values between two range from QVD?

Any why my date field in qvd is a numeric value?

Thanks in advance

Regards

Re: Date Range Selection

MayilVahanan — Mon, 26 Aug 2013 11:27:09 GMT

Are you want to restrict the date range from script level? If so,

Load * from sample.qvd(qvd) where Date(Floor(ModDate),'MM/DD/YYYY') >= '08/01/2013';

QVDs convert datetime format to number format.

Re: Date Range Selection

tresB — Mon, 26 Aug 2013 11:29:05 GMT

try something like this:

Load *, DateField

From <QVD> where Date(DateField,'MM-DD-YYYY') <'01-01-2013' and Date(DateField,'MM-DD-YYYY') >= Date(today(),'MM-DD-YYYY') ;

Hope this gives you an idea.

Re: Date Range Selection

Mon, 26 Aug 2013 11:31:05 GMT

Try this,

TEMP:

Load *,SampleDate

FROM SAMPLE.QVD(QVD)

WHERE DATE(SampleDate,'MM/DD/YYYY') > '01/01/2012' AND DATE(SampleDate,'MM/DD/YYYY') < '12/31/2012'

CONCATENATE

Load *,SampleDate

FROM SAMPLE.QVD(QVD)

WHERE DATE(SampleDate,'MM/DD/YYYY') > '01/01/2013' AND DATE(SampleDate,'MM/DD/YYYY') < '12/31/2013'

If i have understood correctly,you meant 2 date ranges

Re: Date Range Selection

techvarun — Mon, 26 Aug 2013 12:28:52 GMT

Fetched the Data's Correct

Thanks