# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. \$300 savings extended to February 9th Learn More
Not applicable

## How to count days on road with different dimensions

Hi,

please have a look at attached QV doc. I need to be able obtain the number of tripdays by selecting for example two months (see example) and not by using the 'LINK' field.

Available datamodel is one that gives me an ugly solution. I know there should be a much more sofisticated and simple answer to this issue. Please help.

DATA:
Date(Date) as Date,
MonthStart(Date) as CalendarMonthStart,
QuarterStart(Date) as CalendarQuarterStart,
YearStart(Date) as CalendarYearStart,
MonthEnd(Date) as CalendarMonthEnd,
QuarterEnd(Date) as CalendarQuarterEnd,
YearEnd(Date) as CalendarYearEnd,
Month(Date) as Month,
Year(Date) as TRIPYEAR,
Year,
Trip,
FROM TRIPLEDGER);

Enddate,
Startdate,
num(Floor(Enddate-Startdate)+2) as Tripdays
FROM table is dates);

left join (DATA) INTERVALMATCH (Date)
RESIDENT [DATA];

if(year(Enddate)>Year(Startdate), (1+num(Floor(Enddate-CalendarYearStart))),Tripdays) as Tripdays2,
if(Year(Enddate)>=Year(Date), '1', '0') as FLAGTripdays
Resident [DATA];

Sjoerd

Tags (3)
1 Solution

Accepted Solutions
MVP

## How to count days on road with different dimensions

I don't know quite what you want. Maybe this?

sum(aggr(if(month(Enddate)>month(max(CalendarMonthStart))

3 Replies
Not applicable

MVP

## How to count days on road with different dimensions

I don't know quite what you want. Maybe this?

sum(aggr(if(month(Enddate)>month(max(CalendarMonthStart))