topic Re: dynamic bucketing using excel in QlikView

dynamic bucketing using excel

Wed, 25 Nov 2020 16:16:04 GMT

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

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 — Thu, 20 Jul 2017 03:27:45 GMT

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

Thu, 20 Jul 2017 09:10:43 GMT

hi,

i do not want to change my script always.

Thu, 20 Jul 2017 09:14:20 GMT

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;