Alternative States for T-test groups

[car3489]

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! 

[mato32188]

Hi @car3489 ,

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

br

m

[car3489]

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?