Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavvibudagam
Creator II
Creator II

How to calculate Mean from Frequency field

Hi Experts,

Can any one please help me on below requirement to calculate Mean and Standard Deviations in the attached excel.

Here the Mean is calculated from the Frequency field and aggregated by month like

Mean                                        Standard Deviation

N/A                                             N/A        

=SUM(I9:I10)/2                           = STDEV.P(I9:I10)

=SUM(I9:I11)/3                           = STDEV.P(I9:I11)

=SUM(I9:I12)/4                          = STDEV.P(I9:I12)

How to calculate these Excel calculations in Qlik. Please help me on this.

Thanks in advance

10 Replies
sunny_talwar

Check this out

Capture.PNG