Qlikview syntax for the sql query

Anonymous — Tue, 11 Sep 2012 08:42:14 GMT

Hi,

I would like to know the Qlikview syntax for the below sql syntax.

How to assign a value to a variable like below in Qlikview.

Declare @MinEventID

@Fristday DateTime,

SELECT @Fristday = convert(varchar(10), Getdate(),101)

SELECT @MinEventID = MIN(eventid)

FROM table1

WHERE datefield > (SELECT DATEADD(dd,-(DAY(DATEADD(mm,1,@Fristday))-1),DATEADD(mm,-1,@Fristday)))

Thanks in advance

Regards,

Leni Balakrishnan

Re: Qlikview syntax for the sql query

sbaldwin — Tue, 11 Sep 2012 09:39:23 GMT

Hi, try something like this:

set v_Fristday = '15/07/2012';
let v_Fristday = date(monthstart(num(MonthStart(v_Fristday))-1));

temp:
load
min(eventid) as temp;
SQL select eventid from tevents
WHERE screateddate > convert(datetime,'$(v_Fristday)',103);

let v_MinEventID = peek('temp',-1,'temp');

Thanks

Steve