topic Using hidden scripts in QlikView

Using hidden scripts

Thu, 26 May 2011 01:34:40 GMT

Hi, I have created a basic report document which works fine pulling data from SQL Server.

When I move the sql commands from a standard tab to a hidden script, I get:

"ODBC connection failed"

My OLEDB connect 32 statement is set in the default "Main" tab, I have also tried moving it to the hidden script yet the same issue occurs.

Am I not meant to place SQL commands in a hidden script? Or am I just doing it wrong?

Cheers for any help!

Andrew

deepakk — Thu, 26 May 2011 03:47:46 GMT

hi Andrew,

As per my understanding the hidden script executes first and then the rest.

Also first you need to establish a connection and then executes.

Generally we dont add Sql queries in hidden script.

Hidden script are used for Section Access script or any other data information which we don't want to disclose to other developers.

Since the SQL Script doesn't contain any data , we don't write in hidden script.

Regards

Deepak

Thu, 26 May 2011 05:06:58 GMT

Can you attach the sample?