Discussion board where members can get started with QlikView.
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
I tired this and working for me.
Please use the below script.
sql with CTE
select * from Certification.dbo.Employee
select * from CTE;
Its working for we.
Please find the below.