1 Reply Latest reply: Jan 20, 2015 6:26 AM by Bhavani Kumar RSS

    Using CTE with Qlikview Load statement

    cheryl bunch

      Hey All,

      I am new to Qlikview and trying to load a SQL CTE statement. I read a blog post and looks like you can do it, but I am having problems using it with Load.

      This works with no error but putting a LOAD *; statement in front does not.

       

       

       

       

       



      SQL with CTE

      as

      (

      SELECT

       



       

       

      *

      FROM

       



       

       

      Certification.dbo.Employee

      )

      select

       



       

      * from

      CTE