topic Re: Average and standard deviation for calculation in QlikView

Average and standard deviation for calculation

Thu, 01 Aug 2013 09:36:37 GMT

Hi,

I want to calculate average and standard deviation for tha following calculation

(1- (1-sum({<Source={'MFR'}>}Process_Rejected_Parts)

can any one tell how to do that?

Thanks in Advance.

pennetzdorfer — Thu, 01 Aug 2013 09:53:08 GMT

Your expression lacks some brackets ... could you provide more details what you trying to calculate? Maybe an example qvw?

This recent blog post could help you Average... – Which average?

Regards,

Florian

Thu, 01 Aug 2013 10:01:06 GMT

Hi,

I have displayed the values for the calculation

(1- (1-sum(Process_Rejected_Parts))) against time period in chart.

and also i want to display the reference line for average of above calculated value in the same chart.

please guide.

pennetzdorfer — Thu, 01 Aug 2013 10:11:08 GMT

Please try the Trendline "Average" in the Expressions tab of the chart properties:

Hope that helps,

Florian

PS: I guess you could reduce your expression to sum(Process_Rejected_Parts) ...