Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-09-24 05:55 AM

Calculating the 2-Week Moving Average of % Bi-weekly ?

Friends,

How to calculate the 2-Week Moving Average of % Bi-weekly ?


I have the formula to calculate this. But which is showing wrong  values.

(If(RowNo() > 0, Ceil(Aggr(Rangesum(Above(Sum(A), 0, Rowno() )+ Sum(A)), isoWeek) / Aggr(Rangesum(Above(Sum(B), 0, Rowno() ) + Sum(B)), isoWeek)*100,0.01))))

Could you help me to solve this?

Regards

Thiru

362 Views
0 Likes
0 Replies