Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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?