topic Re: Grouping by a value range in QlikView

Grouping by a value range

villegasi03 — Tue, 11 Dec 2012 17:57:16 GMT

I have a table that looks like:

EmployeeID

Date

Calls

TalkTime

Class

My goal is to findout what the average talk time is for each class but I want to group by a range of total calls. So in other words I want to know what each classes average talk time is after taking their first 100 calls then 200 calls and so on. Is there any suggestions that you can provide.

Thank you

Re: Grouping by a value range

vgutkovsky — Tue, 11 Dec 2012 21:38:09 GMT

If you don't need the chart to be overly dynamic, I would suggest creating an additional field in the script to represent the total number of calls per class/day/employee. If you need it to be more dynamic, then you would need to create a calculated dimension in the chart similar to the following:

aggr(

if(count(distinct Calls)<100,

'Less than 100',

if(count(distinct Calls)<200,

'100 - 200',

'Other'

)

Class,EmployeeID,Date

)

Regards,

Vlad

Re: Grouping by a value range

villegasi03 — Wed, 12 Dec 2012 18:01:28 GMT

Worked like a charm thank you