Discussion board where members can get started with QlikView.
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.
Go to Solution.
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
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.
Thanks !!.. this helps
thanks this helps
Please close the thread by marking correct answer