topic Calculating Weekend vs. NonWeekend Stay in QlikView

Calculating Weekend vs. NonWeekend Stay

Wed, 03 Aug 2011 17:59:24 GMT

I'm trying to calculate the number of air itineraries where an air traveler has a weekend stay included and when an air traveler does not have a weekend stay included. The data I have is the following:

Air intinerary (Field: air_itin)

Air travel date (Field: air_travel_date)

No. of days traveling (Field: itin_trip_days)

Day of week with 1=Sun and 7 = Saturday (Field: DayofWeek.Weekday)

Is there a way to do the following:

1. Calcuate the full date range of trip by using: (air_itin) to (air_itin + itin_trip_days)

2. Apply the Day of Week to this date range

3. Flag as Weekend stay if range includes a 6 or 7

Any help is greatly appreciated.

Calculating Weekend vs. NonWeekend Stay

danielrozental — Wed, 03 Aug 2011 18:49:52 GMT

how about something like this

if(weekday(air_travel_date)+1+itin_trip_days>=6,1,0) AS HAS_WEEKEND

Re: Calculating Weekend vs. NonWeekend Stay

Wed, 03 Aug 2011 19:30:18 GMT

Hi Daniel,

Thank you for the input. If I was to link to the each air itinerary in the data set, would I have to run this in my script as a partial reload? Is there any special syntax I need to use aside from the if function if so?

Otherwise, I'm happy to just calculate the number of hotel itineraries that have a weekend stay, but in trying to input the formula am getting an error in the expression. This is what I have as the formula currently:

Count(
if((weekday([air_travel_dt])+1+[itin_trip_days])>5),
[HOTEL.hot_itin])

If there is a manual or resource with examples for different types of functions, I'd love to download a copy!

Thanks again,

Kelly

Re: Calculating Weekend vs. NonWeekend Stay

danielrozental — Wed, 03 Aug 2011 19:32:47 GMT

I think you have a couple misplaced ")"

Count( if((weekday([air_travel_dt])+1+[itin_trip_days]>5, [HOTEL.hot_itin]))

No, this doesn't need to be included in the load, you could do this as an expression in a chart. Although it might be preferable performance wise.