Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi @car3489 ,
this might help you https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Examples%20of%20A....
br
m
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?