Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ryanfliehman
Contributor II
Contributor II

Calculating 3 month Rolling Average w/ If Statement

Hello,

I'm trying to figure out how to calculate a 3 month rolling average for a turnaround time in a combo vizlib chart using MonthYear as my X-Axis.

Below is the criteria I used to come up with the average by month but when trying to calculate a 3 month rolling average using the criteria below I run into issues. Any help would be greatly appreciated. criteria. 

Avg(If([ENCOUNTER.PATIENT CLASS]='Emergency' and Match([Procedure.Code],'LAB8581'),[LAB TEST.FIRST FINAL VERIFIED INSTANT]-[ENCOUNTER.ADMISSION INSTANT]))

0 Replies