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.