Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
car3489
Contributor II
Contributor II

Alternative States for T-test groups

Hello,

I have two alternative states (Sample-A & Sample-B) which allows the user to select any combination of the data to compare. However i would like to use the T-test functions but i cannot work out a way in which i can group the two alternative states. I was thinking along the lines of 

If({Sample-A}[ID], 'Sample-A','Sample-B') of course adding another if else statement to null non selected IDs to give something like this:

Grouping ID Value
Sample-A 123 5
Sample-B 321 1
Null 222 4

 

This would then mean i could use the Grouping and value in the T-test functions.

Any help is greatly appreciated! 

Labels (4)
2 Replies
mato32188
Specialist
Specialist

Hi @car3489 ,

this might help you https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Examples%20of%20A....

br

m

ECG line chart is the most important visualization in your life.
car3489
Contributor II
Contributor II
Author

Thank you however i cannot seem to work out how to use this to gain a group for the different rows (IDs) that can be used in the T-test function.

What i would want to do is something like this pesudo code for a Grouping column:
{[Sample-A]+[Sample-B]}StateName()

If StateName() is replaced with a field that is common in the sample but different in both samples this works. 

For any comparitive analysis i would think this should be possible?