topic Data selection with Date range in QlikView

Data selection with Date range

uttamdwibedy — Tue, 29 May 2012 06:38:24 GMT

Hi, every one, Hope all are working great....!!

Here I want to extract the data by selecting the from date & to date.

For ex. To extract all vessel calls between DD-MMM-YYY to DD-MMM-YYYY.

But while I am adding the calender object & linking the appropriate field (NeedbyDate) It is not coming what I required actually.

Can you help me !!?? Attached the .qvw file I am working on.

Data selection with Date range

Anonymous — Tue, 29 May 2012 07:14:29 GMT

Hi,uttamdwibedy

you create two variables ie vFromDate='01/01/2012' and vToDate ='26/05/2012'

.then in your chart expression you filter the expression like this (

count({<NeedbyDate={'>=$(=(vFrom))<=$(=(vTo))'}>}fieldvalue) .

in front end create an input box fetch these two variable and select the date range.

arunreddy

Data selection with Date range

yvesqlik — Tue, 29 May 2012 08:21:09 GMT

I have just change the name of Dimension in the chart

Re: Data selection with Date range

uttamdwibedy — Tue, 29 May 2012 08:31:24 GMT

Thanks Arun,

But I want to perform this by two calender objects.

Like one calender will be for from date & another one is for to date.

So that It will be help to extract the report in between dates, & easier to understand , would you help me ?

Re: Data selection with Date range

uttamdwibedy — Tue, 29 May 2012 08:40:34 GMT

Sorry guys ,,..!! I have add the wrong qvw.

Pls. check this .qvw . & Pls. kindly suggest me on my pre-said issue ..!!

Re: Data selection with Date range

Tue, 29 May 2012 12:43:56 GMT

See attached for what I think is the solution.

BTW: this post helped me using date selections: http://community.qlik.com/qlikviews/1075

I edited it a few times, because the table returned me all rows when the FROM-date was after the TO date (e.g. from april 2012 to febr 2012). That I tackled with this expression. Perhaps there are better ways to do it...

=
if(From>To,null(),
only({<NeedbyDate={'>=$(=Date(From))<=$(=Date(To))'}>} NeedbyDate))

Hope it helps. I'd like to hear!

Re: Data selection with Date range

uttamdwibedy — Thu, 31 May 2012 02:59:29 GMT

Yes ,Roberto , implemented well in my model., thanks for your utmost assistance. .....!!