Hi All,
| PLAYERNAME |
PRIMARY |
SECONDARY |
DEVICE CONNECTION |
RESULT |
| PRADNYA |
5Min |20Min | |
5Min | |
PASS |
PRIMARY | SECONDARY |
| RAHUL |
10 Min |
|
FAIL |
PRIMARY| DEVICE |
help me construct IF condition to get the "RESULT" column in Qlik Table in UI. I'm trying to use "OR" condition but of no use.
I used below syntax but its using "AND" condition only appears if wither of below clause is satisfied and returns the result however I want "OR" condition.
IF( SP_3_MIN_TEST_STATUS_FAILED = 'FAIL' OR SP_5_MIN_TEST_STATUS_FAILED = 'FAIL' OR
SP_10_MIN_TEST_STATUS_FAILED = 'FAIL' OR SP_20_MIN_TEST_STATUS_FAILED ='FAIL','SECONDARY POWER ISSUE',
IF( PP_3_MIN_TEST_STATUS_FAILED = 'FAIL' OR PP_5_MIN_TEST_STATUS_FAILED = 'FAIL' OR
PP_10_MIN_TEST_STATUS_FAILED = 'FAIL' OR PP_20_MIN_TEST_STATUS_FAILED ='FAIL','PRIMARY POWER ISSUE',
IF(IS_SECONDARY_POWER_SOURCE_CONNECTED_FAILED='FAIL','SEOCONDARY CONNECTION FAILED' )))
