topic Re: How can I create logical buckets using data from a column in load script? in QlikView

How can I create logical buckets using data from a column in load script?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

My Data has a

1. Field : name of the field is [AHT_of_Call]. Using this data I first need to build AHT bucket (as shown in the table below).

then once these buckets are available i want to count the number of records by people (which i will take from field name Created By).

I am struggling to build AHT Buckets (shown in table below) in the Load Script.

Please help

Bucket	Madhukar	Naveen	Premansh	Taufeeq	Total
60-300	158	67	52	214	491
300-420	0	1	0	4	5
420-540	0	0	0	0	0
540-660	0	0	0	0	0
660-720	0	0	0	0	0
720 & Above	0	0	0	0	0
Total	158	68	52	218	496

Re: How can I create logical buckets using data from a column in load script?

shiveshsingh — Thu, 22 Feb 2018 06:12:42 GMT

You can create buckets by calculated dimension

=if([Aht Of Call]>=60 and [Aht Of Call]<=300,'60-300',if([Aht Of Call]>='300' and [Aht Of Call]<='420', '300-420',if([Aht Of Call]>='420' and [Aht Of Call]<='540','420-540',

if([Aht Of Call]>='540' and [Aht Of Call]<='660', '540-660', if([Aht Of Call]>='660' and [Aht Of Call] ='720', '660-720', '720 & Above')))))

Re: How can I create logical buckets using data from a column in load script?

kaushiknsolanki — Thu, 22 Feb 2018 06:16:27 GMT

Hi,

You can write simple if statements like below.

If( [AHT_of_Call] <=60,'0-60',

If( [AHT_of_Call] <=300,'60-300',

If( [AHT_of_Call] <=420,'300-420',

.......... ) as Bucket

And use this field in your chart dimension.

Regards,

Kaushik Solanki

Re: How can I create logical buckets using data from a column in load script?

Anonymous — Thu, 22 Feb 2018 06:37:14 GMT

Thanks !!.. this helps

Re: How can I create logical buckets using data from a column in load script?

Anonymous — Thu, 22 Feb 2018 06:37:24 GMT

thanks this helps

Re: How can I create logical buckets using data from a column in load script?

shiveshsingh — Thu, 22 Feb 2018 06:48:13 GMT

Please close the thread by marking correct answer