SQL writing CASE WHEN ELSE statement

[mattbrain]

Am writing a QlikView load script, and am having an issue with a script.

The source of the information is direct from SQL, this is not a QVD load script.

Am trying to write something like this:

CASE WHEN [EXAMPLE] in (1,2,3,4) then 'Online'  else
CASE WHEN [EXAMPLE] in (5,6,7,8) then 'Offline' END as [ONLINE_or_OFFLINE],

Any assistance would be greatly appreciated. Thanks

[Anil_Babu_Samineni]

This?

If(Match([EXAMPLE], '1','2','3','4'), 'Online',
f(Match([EXAMPLE], '5','6','7','8', 'Offline')) as [ONLINE_or_OFFLINE],

[sunny_talwar · Accepted solution]

May be try this

CASE
          WHEN EXAMPLE IN (1, 2, 3, 4) THEN 'Online'
          WHEN EXAMPLE IN (5, 6, 7, 😎 THEN 'Offline'
       END
          ONLINE_or_OFFLINE

[mattbrain]

Amazing, thats working thanks. I thought there needed to be an "else" condition somewhere.

Thank you, you have saved me so much time