Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
balrammahato204
Creator
Creator

Nested if


Hi all

Please help me

i have 4 condition and i am not able to put my condition in If condition

could you please help me

please find the scaniario

CASE #1: If BA_TEST_CODE = 'SY', and Stamp code>=9000 and Stamp code<=9999
then 'LYMP else 'LYDP'.

CASE #2: If BA_TEST_CODE = 'IL' then set as 'ILA'

CASE #3: If BA_TEST_CODE = 'PS' then set as 'LRA'

CASE #4: BA_TEST_CODE IS NOT ('SY', 'IL', 'PS') then set as 'POOL'

1 Reply
MK_QSL
MVP
MVP

IF(BA_TEST_CODE = 'IL', 'ILA',

IF(BA_TEST_CODE = 'PS', 'LRA',

IF(BA_TEST_CODE = 'SY' and Stamp_Code >= 9000 and Stamp_Code <= 9999, 'LYMP',

IF(BA_TEST_CODE = 'SY' and (Stamp_Code < 9000 or Stamp_Code > 9999), 'LYPD',

IF(Not Match(BA_TEST_CODE,'IL','PS','SY'),'POOL')))))