Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
GA85
Contributor
Contributor

Qlikcloud - Executing non-SELECT queries

Hey,
 
i'm using variables for my SQL Statement and set them with a lot of declare's.

On my Desktop Qlik I'm able to Change my  config file with  <add key="allow-nonselect-queries" value="True"/> that this works.


In the Qlikcloud enviroment i have now the same error again
(Connector error: Executing non-SELECT queries is disabled. Please contact your system administrator to enable it.)
My SQL Statement is like this (just an easy example)

SQL
declare @startdate as datetime = '2019.09.01'

select column_a,column_b from table_X where columndate >= @Startdate;

The used SQL is much more complex 😉 - so using the Statement without declare's at the beginning is not an Option for me. Is there any Option in QLIKCloud that this will work - are there some Settings or hints?

5 Replies
gaidamichal
Partner - Contributor III
Partner - Contributor III

Hello,

Have you got around it somehow? I've got the same issue.

Aleks24
Contributor II
Contributor II

Someone has solution for Qlik Sense Business (Cloud)? How to enable non-select queries ?

artemibe
Contributor
Contributor

Any solution???. Also have this problem in CLOUD version.

langelwong
Partner - Contributor III
Partner - Contributor III

Hey ,

do you found a solution to this?

Aleks24
Contributor II
Contributor II

Hi,

There is no solution yet. But I've already posted this issue to "Ideas". Probably it should be reviewed in future cloud updates.

See : Executing non-SELECT queries with Qlik Sense Business