topic How to declare SQl variables in Qlik sense script in App Development

How to declare SQl variables in Qlik sense script

sims — Fri, 16 Jul 2021 07:59:35 GMT

How can I declare the SQL variable below in Qlik sense script and use them in the SELECT statement.

Thanks in advance.

DECLARE @startDate DATETIMEOFFSET = NULL
DECLARE @endDate DATETIMEOFFSET = NULL
DECLARE @transactionDateTimeFromLocal DATETIME = CONVERT(DATETIME, SWITCHOFFSET(@startDate, '+00:00'))
DECLARE @transactionDateTimeToLocal DATETIME = CONVERT(DATETIME, SWITCHOFFSET(@endDate, '+00:00'));

SELECT

-------

Re: How to declare SQl variables in Qlik sense script

dbodlovich — Tue, 29 Mar 2022 13:13:33 GMT

hi!, i have the same doubt, did you solve it?

Re: How to declare SQl variables in Qlik sense script

Or — Tue, 29 Mar 2022 13:23:19 GMT

You can use SET or LET to set Qlik variables and then use those in your select statements. See e.g. https://community.qlik.com/t5/QlikView-App-Dev/Can-QV-use-variables-in-SQL-SELECT/m-p/38883