Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

stew_scott90
New Contributor II

SQL Substring

I use the following Substring in an SQL statement in a few different apps and it works as expected:

Substring(Upper(Coeuser),10,100)as `MgrCoeuser`

I've created a new app and am trying to reuse the string above and I'm receiving the following error(see image):error image.PNG

If I remove the Substring statement the data load completes without any issues.

Tags (2)
4 Replies

Re: SQL Substring

Do you do the above within the LOAD statement or SELECT statement? I guess other dashboards might do it in LOAD and this one is doing in SQL SELECT.

stew_scott90
New Contributor II

Re: SQL Substring

This is located in the SELECT statement. When I try putting it in the LOAD it highlights the statement as an error.

Re: SQL Substring

Can you share the old and new script (just the load for a single table is enough)

Re: SQL Substring

What database platform are you connecting to?

-Rob

Community Browser