dynamic bucketing using excel

[#1]

Hi Friends,

i would like to get the bucketing in qlikview using the excel data , the below one is my bucketing data.

i have a field TAT which contains 1 to 100000

TATFloor	TATCeiling	TATBucket
1	1	1 day
2	2	2 days
3	3	3 days
4	5	4 to 5 days
6	10	6 to 10 days
11	29	11 to 29 days
30	100000000	More than 30 days

If i select TAT is 7 it should get select 6 to 10 days like..

i do not want to do this..

if(TAT=0 or TAT=1,'1 day',if(TAT =2,'2 days',if(TAT =3,'3 days',

if(TAT=4 or TAT=5 ,'4 to 5 days',

if(TAT>5 and  TAT<=10,'6 to 10 days',if(TAT>=11 and  TAT<=29,'11 to 29 days',

if(TAT>29,'More than 30 days'))))))) as TATBucket,

please help me.

[techvarun]

I guess that't the only way. can you tell me the reason why you don't want this

[#3]

hi,

i do not want to change my script always.

[#4 · Accepted solution]

got the answer.

we can do it two ways..

1. first left join with the main table and in  resident load we can define like

if(TAT >= TATFloor and TAT <= TATCeiling,TATBucket) as TATbucket  or

main table

left join(Tatbucketmap)

IntervalMatch (TAT)

load TATFloor,

     TATCeiling

  Resident Tatbucketmap;