Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
danielnevitt
Creator
Creator

Avg Sum or RangeAvg

Hi,

I have the below data:

Desk            Month 1         Month 2        Month 3        Month 4

A                    200                  250                  225                 275 

B                    300                  200                  100                200 

How do I calculate the average across each desk for the four month period?  Also how would I calculate it if I wanted to only use month 2, 3 and 4 for the average?

Thanks,

Daniel

1 Solution

Accepted Solutions
Taoufiq_Zarra
Master II
Master II

If I understood correctly

RangeAvg(Month1,Month2,...) as _RangAvg,
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

1 Reply
Taoufiq_Zarra
Master II
Master II

If I understood correctly

RangeAvg(Month1,Month2,...) as _RangAvg,
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post