topic Re: Avg of Calls and Print text objects in QlikView

Avg of Calls and Print text objects

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

I would like to do an average of the below but, I'm not getting the correct result.

=Num(Avg({$<EMPLOYEE=,TEAM=p()>} CALLS_ANSWERED),'#,##0')

Description	Individual	Team
Calls Answered	2,000	Avg of the Team
Average Handle Time	22:37	25:11

Also, i have a couple of text objects to get different call metrics. I would like the capability to have these

text objects printed altogether in a sheet (as seen in the above table). How should i do this? Can you please help? Thank you in advance for your assistance.

Re: Avg of Calls and Print text objects

vishsaggi — Fri, 09 Dec 2016 22:34:11 GMT

Can you share a sample app to look into ?

Re: Avg of Calls and Print text objects

sunny_talwar — Sat, 10 Dec 2016 01:59:02 GMT

How is your raw data look like? what is your expected output?

Re: Avg of Calls and Print text objects

xarapre7 — Mon, 12 Dec 2016 16:14:09 GMT

Hi! Sorry for the delayed response but, what you see above is the expected output. I have metrics description on the left hand side of the table, then the output per individual based on what's selected from the filter and then the Team output which is the Avg.

Re: Avg of Calls and Print text objects

sunny_talwar — Mon, 12 Dec 2016 16:15:18 GMT

Raw data?

Re: Avg of Calls and Print text objects

xarapre7 — Mon, 12 Dec 2016 16:49:40 GMT

Load * inline [

EMPLOYEE, Mgr, COUNTRY, TEAM, CALLS_ANSWERED
Samat, Fad, KL, SUPP SPEC, 7
Abas, Zach, KL, SUPP SPEC, 15
Abas, Zach, KL, SUPP SPEC, 3
Abas, Zach, KL, SUPP SPEC, 4
Abas, Zach, KL, SUPP SPEC, 6
Abas, Zach, KL, SUPP SPEC, 1
Abas, Zach, KL, SUPP SPEC, 2
Abas, Zach, KL, SUPP SPEC, 3
Abas, Zach, KL, SUPP SPEC, 4
Abas, Zach, KL, SUPP SPEC, 5
Abas, Zach, KL, SUPP SPEC, 6
Abas, Zach, KL, SUPP SPEC, 7
Abas, Zach, KL, SUPP SPEC, 9
Abas, Zach, KL, SUPP SPEC, 10
Abas, Zach, KL, SUPP SPEC, 17
Abas, Zach, KL, SUPP SPEC, 5
Abdel, Remi, KL, SUPP SPEC, 0
Abdel, Remi, KL, SUPP SPEC, 1
Abdel, Remi, KL, SUPP SPEC, 2
Abdel, Remi, KL, SUPP SPEC, 3
Abdel, Remi, KL, SUPP SPEC, 4
Abdel, Remi, KL, SUPP SPEC, 6

];

Re: Avg of Calls and Print text objects

xarapre7 — Mon, 12 Dec 2016 16:50:11 GMT

Output should be like below:

SUM PER INDIVIDUAL
Row Labels	Sum of CALLS_ANSWERED
Abas,	97
Abdel,	16
Samat,	7
Grand Total	120
AVG OF TEAM
Row Labels	Average of CALLS_ANSWERED
SUPP SPEC,	5
Grand Total	5

Re: Avg of Calls and Print text objects

vishsaggi — Mon, 12 Dec 2016 17:04:46 GMT

Is this you are looking for ?

Pivot table used

Dim: Team

Employee

Expr1: Sum(CALLS_ANSWERED)

Expr2: Avg(TOTAL CALLS_ANSWERED)

Re: Avg of Calls and Print text objects

xarapre7 — Mon, 12 Dec 2016 17:23:31 GMT

Yes, the output you've given is what I'm expecting. However, how will I apply it to my expression below? I added the Total after the AVG and it's not giving the right output.

=Num(Avg({$<EMPLOYEE=,TEAM=p()>} CALLS_ANSWERED),'#,##0')

Re: Avg of Calls and Print text objects

vishsaggi — Mon, 12 Dec 2016 17:58:21 GMT

What is your output you are expecting for this expression ?

Re: Avg of Calls and Print text objects

xarapre7 — Mon, 12 Dec 2016 18:03:28 GMT

Like the one I've shown above.

What this is going to do is, the user needs to select an employee first from the Filter Selection. And based on that employee that's been selected from the list, the above metrics should be displayed. So the employee's number of calls answered and the employee's team's AVG # of calls answered.

Re: Avg of Calls and Print text objects

sunny_talwar — Mon, 12 Dec 2016 18:04:19 GMT

How about this?

=Num(Avg(TOTAL {$<EMPLOYEE=,TEAM=p()>} CALLS_ANSWERED),'#,##0')

Re: Avg of Calls and Print text objects

vishsaggi — Mon, 12 Dec 2016 18:12:38 GMT

Is the expression not working it is not giving you the avg of 5?

In the above output you need the Sum and avg on two different tables or one below the other ?

I used your expression in the team average like

=Num(Avg(TOTAL {$< EMPLOYEE=, TEAM = p(TEAM) >} CALLS_ANSWERED),'#0')

Re: Avg of Calls and Print text objects

xarapre7 — Mon, 12 Dec 2016 18:20:56 GMT

Hi Sunny T!

Thanks for the input. I've already tried doing that and it didn't work. It just gave an output of dash (' - ').

Re: Avg of Calls and Print text objects

vishsaggi — Mon, 12 Dec 2016 18:29:19 GMT

Can you share your sample app you were working on which you are not getting the desired results?

Re: Avg of Calls and Print text objects

xarapre7 — Mon, 12 Dec 2016 18:52:26 GMT

did you see the file?

Re: Avg of Calls and Print text objects

vishsaggi — Mon, 12 Dec 2016 18:57:27 GMT

Nope, dont see any attachment!

Re: Avg of Calls and Print text objects

xarapre7 — Mon, 12 Dec 2016 19:03:19 GMT

Here you go.

Re: Avg of Calls and Print text objects

sunny_talwar — Mon, 12 Dec 2016 19:23:00 GMT

Are we looking to get this right?

0:12:20 is not right for Abas, Lendion Zachary?

Re: Avg of Calls and Print text objects

xarapre7 — Mon, 12 Dec 2016 20:56:41 GMT

That one and the one above that. The Calls Answered for the Team. We want the Avg per Team.