Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
This?
If(Match([EXAMPLE], '1','2','3','4'), 'Online',
f(Match([EXAMPLE], '5','6','7','8', 'Offline')) as [ONLINE_or_OFFLINE],
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
Amazing, thats working thanks. I thought there needed to be an "else" condition somewhere.
Thank you, you have saved me so much time