Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Using CTE with Qlikview Load statement

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

1 Reply
Not applicable

Re: Using CTE with Qlikview Load statement

Hi,

I tired this and working for me.

Please use the below script.

Script:

load *;

sql with CTE

as

(

select * from Certification.dbo.Employee

)

select * from CTE;

Its working for we.

Please find the below.