Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI
PFA
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))
HI
PFA
Hey All!
Thank you very much it was very helpful.