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:
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:
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.