Chi Squared Calculations

[HillaryRyder]

Hi,

I am trying to create a straight table with chi squared probability as an expression. My data hears would look as such

Batch       Material Number          Line        Measurement Name           Value

Each batch we produce take multiple results for each measurement name. 

Batch       Material Number          Line        Measurement Name           Chi^2

Above is the structure of the table I have created however I cannot figure out what the fields go into the chi squared formula. I want each row to have a chi squared value based off the value recorded for the batch, material number, line and measurement name in that row. 

Any help is appreciated.

[chrismarlow]

Hi,

It is not clear how in your data you would split between/calculate observed and expected values, so difficult to say how to then apply the formulae.

Have you looked here Examples of how to use chi2-test functions in charts ‒ QlikView which might help you get an idea of how this works in Qlik?

Cheers,

Chris.