Using CTE with Qlikview Load statement

Wed, 09 Feb 2011 17:12:44 GMT

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

(

SELECT

FROM

Certification.dbo.Employee

)

select

* from

CTE

Re: Using CTE with Qlikview Load statement

Tue, 20 Jan 2015 11:26:39 GMT

Hi,

I tired this and working for me.

Please use the below script.

Script:

load *;

sql with CTE

(

select * from Certification.dbo.Employee

)

select * from CTE;

Its working for we.

Please find the below.

topic Using CTE with Qlikview Load statement in QlikView

Using CTE with Qlikview Load statement

Re: Using CTE with Qlikview Load statement