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.