if Syntax Error

[embruqlikview]

Hi there

i have a simple question:

In QlikView I used if statements during load to change data values.

The same syntax seams not working in QlikSense?

I want change a string value during load:

if ( BusinessUnits.BusinessUnitName = "ID Büro / Klassiker", "ID Büro/Klassiker", BusinessUnits.BusinessUnitName) as Abteilung,

I get an syntax error:

The following error occurred:
ERROR [42000] Incorrect syntax near the keyword 'if'., Incorrect syntax near ','.,

[Chanty4u · Accepted solution]

Try this

    if(BusinessUnits.BusinessUnitName = 'ID Büro / Klassiker', 'ID Büro/Klassiker', BusinessUnits.BusinessUnitName) as Abteilung

[embruqlikview]

Thanks - this was my first try.

I get the same error.