topic Re: SQL writing CASE WHEN ELSE statement in QlikView

SQL writing CASE WHEN ELSE statement

mattbrain — Tue, 23 Apr 2019 13:02:02 GMT

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 — Tue, 23 Apr 2019 13:05:33 GMT

This?

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

sunny_talwar — Tue, 23 Apr 2019 13:30:07 GMT

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 — Tue, 23 Apr 2019 13:51:13 GMT

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

Thank you, you have saved me so much time