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.
