Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Anderson-Darling statistic test


I am searching someone that has created in a qvw the Anderson-Darling Normality test.

I am trying to create some six sigma dashboard in qlikview, but it is not supporting so much statistics functions.

Thanks for your help

1 Reply
Specialist II
Specialist II

$(x) your field

N : sample size

Average :

mu = avg(total $(x))


Corrected standard deviation :

S* = stdev(total $(x)) * N/(N-1)


stantardized gap :

e = ($(x) - mu) / [S*]


Value of e for row rank N - i + 1 :

[en+1-i] = bottom(e,rowno())


A2 value :

-1 - (log(normdist(e)) + log(1 - normdist([en+1-i])) ) * (2*rowno() -1)