Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
jsteyn
Creator
Creator

Qliksense Business Cloud - CTE's?

Hi All

Need to know if Qliksense business cloud supports CTE's. I am getting the following error.

I also tried the !EXECUTE_NON_SELECT_QUERY at the end of my sql query without success.

 

Capture.PNG

Labels (2)
1 Solution

Accepted Solutions
jsteyn
Creator
Creator
Author

Ok so 5 months later i found the solution 😅

 

https://support.qlik.com/articles/000065604

View solution in original post

5 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Which connector are you using?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jsteyn
Creator
Creator
Author

PostgreSQL

jonathandienst
Partner - Champion III
Partner - Champion III

According to the documentation, this connector is still in Beta for Qlik Cloud. Its possible that CTE's are not supported or not working.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jsteyn
Creator
Creator
Author

Thanks, looks like I will have to just work without CTE's until implemented by the Qlik team.

 

jsteyn
Creator
Creator
Author

Ok so 5 months later i found the solution 😅

 

https://support.qlik.com/articles/000065604