Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ','.,
Try this
if(BusinessUnits.BusinessUnitName = 'ID Büro / Klassiker', 'ID Büro/Klassiker', BusinessUnits.BusinessUnitName) as Abteilung
Try this
if(BusinessUnits.BusinessUnitName = 'ID Büro / Klassiker', 'ID Büro/Klassiker', BusinessUnits.BusinessUnitName) as Abteilung
Thanks - this was my first try.
I get the same error.