Solved: Re: use average as partial sum - Qlik Community

anuradhaa · ‎2016-07-21

Hi ,

please check attached qvw. i want to get average hours and colur it in red when average is less than 8.

is it possible.

sunny_talwar · ‎2016-07-21

Are you trying to get this?

View solution in original post

Report Inappropriate Content · ‎2016-07-21

Please find attached.

anuradhaa · ‎2016-07-21

No, this is not what i want.

i want to get the average of all the dates

sum(sum(hours)) - for all 10 days / count(number of days) 10

PrashantSangle · ‎2016-07-21

hi,

try with total

like Sum(Total hours)/ count(distinct number of days)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2016-07-21

Try this pls.

tyagishaila · ‎2016-07-21

Let me know.

if you don't get required result.

anuradhaa · ‎2016-07-21

no, you get daily average for all members, but i want the average hours of each member for whole period

anuradhaa · ‎2016-07-21

can you please share a sample

sunny_talwar · ‎2016-07-21

Are you trying to get this?