Data selection with Date range

[uttamdwibedy]

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.

[Anonymous]

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

[yvesqlik]

I have just change the name of Dimension in the chart

[uttamdwibedy]

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 ?

[uttamdwibedy]

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

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

[#6 · Accepted solution]

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!

[uttamdwibedy]

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