Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
dhanavindhan
Creator
Creator

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
stigchel
Partner
Partner

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

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

It seems to work for your attached file

ScrDate.png

Also attached

dhanavindhan
Creator
Creator
Author

Hi,

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

stigchel
Partner
Partner

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