topic Re: How to access CTE table from PostgreSQL to Qlik data load editor? in Move to Qlik Cloud Analytics

How to access CTE table from PostgreSQL to Qlik data load editor?

Vikash938 — Tue, 27 Jan 2026 10:45:26 GMT

I have one CTE (common expression table) table in PostgreSQl database. I want to access that CTE table in data load editor. how to do that?

Re: How to access CTE table from PostgreSQL to Qlik data load editor?

Levi_Turner — Tue, 26 Aug 2025 12:59:08 GMT

Make sure to enable non select queries on the data connection:

But here's a sample which you can use for reference:

LIB CONNECT TO 'PostgreSQL';
LOAD *;
SQL WITH cte1 (temp_var1, temp_var2) AS (
VALUES
(1,4),
(2,5),
(3,6)
)
SELECT 
temp_var1
, temp_var2
, (temp_var1 + temp_var2) AS temp_var3
FROM cte1;

Re: How to access CTE table from PostgreSQL to Qlik data load editor?

Vikash938 — Fri, 29 Aug 2025 04:26:27 GMT

@Levi_Turner can you little bit more? I didn't get it right now.