Webi if statement help

system · January 9, 2020, 4:25pm

Hi a

New to using Webi HANA so looking for some assistance.

I have my field called “=[TK Employee SubGroup (Title) - Text]”, i dragged that field into my table and applied a filter to only show the 6 positions i need , however, i need to make custom titles based on the HANA titles these ppl have, so can someone help me with how to do a “if statement”?

FOr example,

IF [TK Employee SubGroup (Title) - Text] = GLS - Director THEN eDiscovery & Data Advisory
IF [TK Employee SubGroup (Title) - Text] = GLS - Legal Prof THEN Alt Legal Support
IF [TK Employee SubGroup (Title) - Text] = GLS - Manager THEN Alt Legal Support

etc etc

I have 6 other titles that have this type of combination. Is there a way to create a formula or multiple “if statements” like Excel and create a variable that i can drag and drop for custom title?

pls help…been struggling for a few days on this…thxs

blueinkpen (BOB member since 2020-01-09)

system · January 9, 2020, 5:33pm

Is this what you’re after?


    IF [TK Employee SubGroup (Title) - Text] = "GLS - Director" THEN "eDiscovery &amp; Data Advisory" 
ELSEIF [TK Employee SubGroup (Title) - Text] = "GLS - Legal Prof" THEN "Alt Legal Support" 
ELSEIF [TK Employee SubGroup (Title) - Text] = "GLS - Manager" THEN "Alt Legal Support"

Bill K (BOB member since 2011-02-24)

system · January 9, 2020, 6:15pm

yes, that works

i am very new to webi so didnt know how the logic works

appreciate that …i will try and give you feedback

blueinkpen (BOB member since 2020-01-09)

system · January 9, 2020, 7:21pm

Hi there

so I wanted to check

would the formula end like this?

IF [TK Employee SubGroup (Title) - Text] = "GLS - Director" THEN "eDiscovery &amp; Data Advisory"

ELSEIF [TK Employee SubGroup (Title) - Text] = “GLS - Legal Prof” THEN “Alt Legal Support”
ELSEIF [TK Employee SubGroup (Title) - Text] = “GLS - Manager” THEN “Alt Legal Support”
ELSE [TK Employee SubGroup (Title) - Text]

would it end with “ELSE [TK Employee SubGroup (Title) - Text]”

? thxs

blueinkpen (BOB member since 2020-01-09)

system · January 10, 2020, 1:41pm

Try it and see!

Not ending an If statement with an else clause will return nothing if the condition is not met

In your example it will return the value for [TK Employee SubGroup (Title) - Text]

Ross_BOXI (BOB member since 2018-04-17)