Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
dhanavindhan
Contributor

Date Range

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,

Calender.jpg

Expected Output:

Calender obj.jpg

 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

 

Labels (1)
5 Replies
Partner
Partner

Re: Date Range

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

Re: Date Range

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

Re: Date Range

It seems to work for your attached file

ScrDate.png

Also attached

dhanavindhan
Contributor

Re: Date Range

Hi,

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

Partner
Partner

Re: Date Range

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..