6 Replies Latest reply: Jul 25, 2014 6:51 AM by Erik Korme RSS

    How to utilize a SQL query that includes a semicolon?

      I want to use an existing SQL query that uses Common Table Expressions in QlikView. The CTE requires that the preceeding SQL code be terminated with a semicolon before the "WITH" command. Unfortunately, QlikView interprets this semicolon as the end of the SQL statement. Does anyone know a workaround for this? Thanks!