Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Average Sales based on month selection

Hi All,

I want to show YTD Sales Average for Dept1  in a pivot table with month selection as shown below:

 

MonthSalesYTD Avg Sales
Jan-161010
Feb-162015
Mar-163020
Apr-164025
May-165030
Jun-166035
Jul-167040
Aug-168045
Sep-169050
Oct-1610055

Please help me. Thanks in advance.

12 Replies
tresesco
MVP
MVP

Have you tried : Aggr(Rangeavg(Above( sum({<Month>}Sales),0,RowNo())), Dept,Month)  ?

susovan
Partner
Partner

Hi,

But I have checked that the value of YTD Avg Sales are same for both chart.

Please find the below screen shot for the ready reference

10.JPG

Warm Regards,
Susovan
Not applicable
Author

tresesco,Taking much time to calculate even with less data.Is there another way to do same calculation ?

Aggr(Rangeavg(Above( sum({<Month>}Sales),0,RowNo())),Dept,Month)

Capture.PNG