topic Re: Set Expression comparing to fields (inequality) in QlikView

Set Expression comparing to fields (inequality)

Wed, 03 Aug 2011 17:07:21 GMT

I'm trying to count the number of hotel bookings (hot_itin) for a "partial stay," whereby a a customer booked a hotel for an amount of time (HOTEL.los) less than his/her air travel dates (itin_trip_days). I can't figure out what I'm doing wrong and have tried multiple iterations, so any help is greatly appreciated.

The code I'm using is the following:

Count(
{$<
[itin_trip_days] = {$('>[HOTEL.los]')}
>}
[HOTEL.hot_itin])

Re: Set Expression comparing to fields (inequality)

danielrozental — Wed, 03 Aug 2011 18:24:40 GMT

That can't be achieved using set analysis, you can try something like this

Count(
if([itin_trip_days] = >[HOTEL.los],
[HOTEL.hot_itin])
)

Re: Set Expression comparing to fields (inequality)

Wed, 03 Aug 2011 19:01:40 GMT

Thanks Daniel, appreciate the help. It didn't like the version with the equal sign, but I removed the equal sign and the below verson works:

Count(
if([itin_trip_days] > [HOTEL.los],
[HOTEL.hot_itin])
)