Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all !
I need some help to understand my problem for using the Chi2Test_p function.
I try the chart exemple given and it works fine. I don't really understand the way to calculate this but it's not really a pb.
Now I try to apply it on a specific set of data (see attachment). But Qlik Sense don't succeed to give me a result.
I simply use the function like that :
Chi2Test_p(Dim1,Dim2,Val)
Does anybody have an idea why I've no result ?
Thanks in advance for any help !
Anybody for a little help ?
I think the data values make difference here. Even I don't understand this function much but I found few data cases work few not. For example, I created this sample data which shows some values.
You may like to view this video to understand further on sample data preparation -
Interpreting the SPSS Output for a Chi Square Analysis - YouTube
I agree with you about the data values quality.
After "cleaning" data, the function accept to calculate something.
"Cleaning" data means :
- No null or 0 values
- Respect of my couple dimensions. For each value for Dim1, I need 2 Dim2.
This condition means :
Dim1 | Dim2 | Val |
---|---|---|
A | 1 | 34 |
A | 2 | 74 |
B | 1 | 12 |
B | 2 | 65 |
C | 1 | 23 |
C | 2 | 41 |
... | ... | ... |
If I don't have the two lines for a Dim1 value, the calculation fails.
I don't really understand too and don't really know if the result is finally right