topic Re: Average for a Team in QlikView

Average for a Team

Thu, 07 May 2015 05:03:51 GMT

Hi Friends ,

I have a requirement , where i have to find the average for a Team and Individual.

i was able to find the average for individual. The expression used is

=((Sum({$<Type = {'Break Time'}>} Duration)/60)/ (Count( DISTINCT{$<Type = {'Break Time'}>} Date)))

Now i have to find the average for the team. How do i acheive it.

The Team header is StaffUnit.

Regards,

Senthil

robert_mika — Thu, 07 May 2015 06:57:05 GMT

Look at aggr function.

Post sample of your data or your qvw file and expected result.

jonathandienst — Thu, 07 May 2015 07:00:01 GMT

Do you want to do this in a text box or in a chart/table; and if chart/table, what are the dimensions?

Thu, 07 May 2015 07:01:58 GMT

Hi..

I want to display it in the Text Object

jagan — Thu, 07 May 2015 07:13:37 GMT

Hi Senthil,

Can you post some sample data and your expected ouput? So that it would be easier to give solution.

Regards,

Jagan.