Qlik Community

New to Qlik Sense

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

Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Alternative States for T-test groups


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

Hi @car3489 ,

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



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

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:

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?