Using CTE with Qlikview Load statement

[#1]

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

[#2]

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.