Avg Hours

[NavinReddy]

Dear All,

Some one help me

How to calculate Avg hours per person per month

Give me some idea

im using personal edition

Thanks In Advance

Niru    

[jsingh71]

Can you share some sample data.

[MK_QSL]

Need at least some sample data !

[sunilkumarqv]

Please find the sample these may help you

and instead of per month i used day, you may change requirement

In expression

avg(Aggr(DISTINCT

Count( Hour),Person,Month))

[NavinReddy]

hi manish,

Please find sample data

person	Payhours	Month
A	10.38	1
B	5.75	2
A	40	1
C	35	2
B	1.75	1
A	3.83	2

Regards,

Niru

[Gysbert_Wassenaar]

Create a chart with the fields Month and person as dimensions and as expression avg(Payhours). If your field names are not Month,person and Payhours, then replace those names with the exact case-sensitive field names of your qlikview document.

[MK_QSL]

Please check enclosed file...

[NavinReddy]

Hi Gysbert,

Thanks for your replay

But i need to create Gauge Chart i need to impliment that expression

but gauge no dimension right Please help me

Regards,

Niru

[Gysbert_Wassenaar · Accepted solution]

Perhaps this: =avg(aggr(sum(Payhours),person,Month))

[NavinReddy]

Hi manish,

i am using personal edition

will you please copy and paste expression here ,im trying to develop in gauge chat

Thanks In Advance

Niru