topic Re: Date Range in QlikView

Date Range

dhanavindhan — Sat, 16 Nov 2024 05:09:49 GMT

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

Re: Date Range

stigchel — Thu, 22 Nov 2018 15:57:45 GMT

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

Re: Date Range

dhanavindhan — Fri, 23 Nov 2018 06:23:59 GMT

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

Re: Date Range

stigchel — Fri, 23 Nov 2018 10:13:46 GMT

It seems to work for your attached file

Also attached

Re: Date Range

dhanavindhan — Fri, 23 Nov 2018 10:16:19 GMT

Hi,

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

Re: Date Range

stigchel — Fri, 23 Nov 2018 10:24:10 GMT

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