Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

average of an item in a period

Hello!

Excuse me I am very new to QlikView and I need your Help.

I need to calculate the average of an item (availibility) in a period (4 last weeks) for each employee: For each employee in my data base I have his availiblity in a certain week, and what I need is to calculate the average of the employee's availibility in the 4 last weeks .

Thank you in adavance

1 Solution

Accepted Solutions
MayilVahanan

HI

PFA

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

3 Replies
Not applicable
Author

see att file

i know it is not a smart solution but you can do it by:

=RangeAvg( sum({$<week={"$(=week(today()))"}>}availiblity), sum({$<week={"$(=week(today())-1)"}>}availiblity),sum({$<week={"$(=week(today())-2)"}>}availiblity),sum({$<week={"$(=week(today())-3)"}>}availiblity))

MayilVahanan

HI

PFA

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Hey All!

Thank you very much it was very helpful.