topic Re: Variables in QlikView

Variables

Fri, 20 May 2016 11:40:53 GMT

Hi,

am still new to qlikview, so I would like to know how to I insert SQL variables in qlikview...please see SQL variables I want to insert

declare @Yesterday varchar (8)

declare @today varchar (8)

declare @FirstDayOfCurrMonth varchar (8)

declare @LastDayOfCurrMonth varchar (8)

set @Yesterday = (select convert(varchar,DATEADD(d, -1, getdate()),112 ))

set @today = (select convert(varchar,getdate(),112 ))

set @FirstDayOfCurrMonth = (select convert(varchar,dateadd(d,-(day(dateadd(m,-0,getdate()-1))),dateadd(m,-0,getdate()-0)),112))

set @LastDayOfCurrMonth = (select CONVERT(varchar,dateadd(d,-(day(dateadd(m,1,getdate()))),dateadd(m,1,getdate())),112))

print @Yesterday

print @today

print @FirstDayOfCurrMonth

print @LastDayOfCurrMonth

thanks

tamilarasu — Fri, 20 May 2016 13:24:34 GMT

Hi,

You can try like below

Let vToday = Today();

Let vYesterday = Date(Today()-1);

Let vMonthStart = Monthstart(Today());

Let vMonthEnd = MonthEnd(Today());

If you want specific date format, you can change the environment variable like SET DateFormat='DD/MM/YYYY'; or whatever required.

Fri, 20 May 2016 13:36:36 GMT

thank you tamil, it helped

tamilarasu — Fri, 20 May 2016 13:56:23 GMT

You are welcome, Dlamini.