Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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.

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.