topic Re: Interval Match in QlikView

Interval Match

kamalqlik — Wed, 27 Feb 2013 06:27:53 GMT

Hi Friends,

I have two table

Users:

LOAD * Inline

[

UserID, Quarter, Hours, BonusId

123,Q1-2011,122,1

224,Q1-2011,103,1

234,Q2-2011,97,2 ];

Bonus:

load * inline

[

BonusId,From_Hours,To_Hours,Bonus

1,75,100,75%

1,101,125,100%

2,79,104,75%

2,105,130,100%];

I want to determine the correct bonus for each user based on the user's hours.How can i do that using Interval Match

Regards

Kamal

Re: Interval Match

Wed, 27 Feb 2013 07:32:29 GMT

LOAD * INLINE [

UserID, Quarter, Hours, BonusId

123, Q1-2011, 122, 1

224, Q1-2011, 103, 1

234, Q2-2011, 97, 2

];

LOAD * INLINE [

BonusId_new, From_Hours, To_Hours, Bonus

1, 75, 100, 75%

1, 101, 125, 100%

2, 79, 104, 75%

2, 105, 130, 100%

];

DATA:

IntervalMatch(Hours)

LOAD From_Hours, To_Hours

Resident b;

BonusId	Bonus
1	75%
1	100%
2	75%

Re: Interval Match

er_mohit — Wed, 27 Feb 2013 07:47:09 GMT

hiii try this

Users:

LOAD * Inline

[

UserID, Quarter, Hours, BonusId

123,Q1-2011,122,1

224,Q1-2011,103,1

234,Q2-2011,97,2 ];

Bonus:

load * inline

[

BonusId,From_Hours,To_Hours,Bonus

1,75,100,75%

1,101,125,100%

2,79,104,75%

2,105,130,100%];

Left Join(Bonus)

IntervalMatch(Hours)

LOAD

From_Hours,To_Hours

Resident Bonus;

Re: Interval Match

Anonymous — Wed, 27 Feb 2013 08:04:06 GMT

Hi Kamal,

Please fiend the attachment of application.