Date Range

[dhanavindhan]

Dear Users,

I have 2 date columns On-HireDate & Off-HireDate.

If I choose On-hiredate it will automatically select it's off-hiredate. 

Like,

Onhiredate : 01-02-2018 means offhiredate : 01-03-2018, in betwwen we have 30 days I want to see those dates in my table when I choose any on-hiredate.

Example:

Currently Like this i have,

Expected Output:

 I choose On-Hiredate as 01-Jan-2018 QV takes it's off-Hire date automatically. But, I wanted to see all the dates falling between them in my report. CH Amount will be same only for some vessel it change remaining vessel shows as empty or 0.  What ever the date range the user choose all should come in my QV report. As of now in my QV i choose 01-Jan-2018 it shows only that date in my qv i want all the records upto offhire-date. Attached qvw file.

Reg,

Dhana R

[stigchel]

You can use set analysis, change your expression On-Hire rate to
sum({<IBSReport.onhireperiod={">=$(=Min(IBSReport.onhireperiod))<=$(=Max(IBSReport.offhireperiod))"}>} IBSReport.onhirerate)

[dhanavindhan]

Hi,
Thnx for ur reply.
It seems, the issue still persist even though after changing the expression.

[stigchel]

It seems to work for your attached file

Also attached

[dhanavindhan]

Hi,

I don't need the min and max dates and b/w dates.

[stigchel]

The Min and max are simply there to make it work even if no date is selected and in case there are more than one date associated with an onhiredate. I don't know what you mean by b/w dates..