# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
New Contributor III

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

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.

 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
Tags (1)
1 Solution

Accepted Solutions
Honored Contributor

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

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')))))

5 Replies
Honored Contributor

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

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'))))) MVP

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

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

New Contributor III

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

Thanks !!.. this helps

New Contributor III

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

thanks this helps

Honored Contributor