Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Want my table to show values > Sigma (1 stddev from average)

I have instances that keeps track of how long a phone call last (Length). I have configured sigma and want a table showing all of the phone calls > sigma.

What is the formula I need to achieve this?

SR stands for the Request, its the call ID

Formula's I have tried:

I created a Variable called Sigma =avg(Length)+stdev(Length)

1.Sum({$<SR={"Length > {$(vSigma)}">}SR)

2.Sum({$<SR={"Length >=avg(Length)+stdev(Length)">}SR)

I want to just show the length of calls that are greater than Sigma. Seems easy enough but I am having troubles.

Anything Helps!

Thanks

2 Replies
Not applicable

Re: Want my table to show values > Sigma (1 stddev from average)

Couple of questions. What type of chart object you are using & what is your Dimension.

As per my understanding the question, you need to calculate total call duration if call length more than sigma (avg(Length)+stdev(Length)) for each Request (SR)  please find below:

vSigma = avg(Length) + stdev(Length)

or

vSigma = avg({1}Length) + stdev({1}Length)  // Ignores current selection

Sum({<Lenghth={">=$(vSigma )"}>} Length)

Please share the sample data to answer your question.

Highlighted
Not applicable

Re: Want my table to show values > Sigma (1 stddev from average)

I have my data in a Simple Table and have all of my fields as a dimension.

Community Browser