Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Using SQL scalar variables in qlikview script

Hi all,

I want to run a SQL query that makes use of several scalar variables. I replaced those with a fixed value with qlikview variables as it is the same thing, but there are some more declared with no initial value as it is dynamic.

Does anyone know how I can use the

SQL declare @bla int
SQL select...

bit in qlikview script? It doesnot seem to like the syntax no matter what I do.

Thanks

Tags (2)
3 Replies
MVP
MVP

Re: Using SQL scalar variables in qlikview script

Hi Joseph,

the SQL statement is passed directly to the database. This could probably work but syntax will not be checked on QlikView site.

- Ralf

Not applicable

Re: Using SQL scalar variables in qlikview script

Thanks Ralf, I am waiting for confirmation that the error codes dont have to do with the backend.

MVP
MVP

Re: Using SQL scalar variables in qlikview script

Which error code? SQL errors? Just post here..

Community Browser