Qlik Community

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
sachinmanan
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.

Please help

      

BucketMadhukarNaveenPremanshTaufeeqTotal
60-3001586752214491
300-42001045
420-54000000
540-66000000
660-72000000
720 & Above00000
Total1586852218496
Tags (1)
1 Solution

Accepted Solutions
shiveshsingh
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')))))

View solution in original post

5 Replies
shiveshsingh
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')))))

View solution in original post

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


sachinmanan
New Contributor III

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

Thanks !!.. this helps

sachinmanan
New Contributor III

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

thanks this helps

shiveshsingh
Honored Contributor

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

Please close the thread by marking correct answer