How to use chi2test_p function

Wed, 16 Jul 2014 21:50:21 GMT

I'm trying to use the chi2test_p function to determine the statistical significance of a data set.

First, I got it to work when using a very simple data set as follows:

Impression	Result	Count
Control Group	Success	1
Control Group	Failure	2
Test Group	Success	2
Test Group	Success	2

If I import this as a table, using this expression produces the correct result: =chi2test_p(Impression,Result,Count)

However, my actual data table imported into qlikview is not pre-aggregated, so it's formatted more like this:

Impression	Result	CustomerID
Control Group	Success	A
Control Group	Failure	B
Control Group	Failure	C
Test Group	Success	D
Test Group	Success	E
Test Group	Failure	F
Test Group	Failure	G

I tried using this expression: =chi2test_p(Impression,Result,Count(CustomerID). This produces an error: "Error: Error in expression: Nested aggregation not allowed"

Any thoughts on what I can do in my working sheet to get the chi2test_p to work?

I've attached the "broken" QVW in case that helps.

topic How to use chi2test_p function in QlikView

How to use chi2test_p function