topic Re: variable date with where clause in loading Qv in QlikView

variable date with where clause in loading Qv

vikasmahajan — Fri, 23 May 2014 05:59:11 GMT

I have following script , I want to fetch date from sql i.e MaxDate and use this variable while loading data but not getting result.

MaxDatetrn:

Load

date(MaxDate,'DD/MM/YYYY') as MaxDate;

SQL SELECT MaxDate

FROM "QLIKVIEW_SIM_DB".dbo.MAXDT;

LET vMaxDate = peek('MaxDate', 0, 'MaxDatetrn');

Fact_DivisionTarget:

LOAD trim(SG_ID) as SG_ID,

date(DivTarDate,'DD/MM/YYYY') as DivTarDate,

DivAnnualTgt,

DivMonthlyTgt,

finyr,

year,

flag

FROM

[..\Excels\SIM\Vikas.xls]

(biff, embedded labels, table is [Sheet1$])

Where DivTarDate <= date(($vMaxDate),'DD/MM/YYYY') ;

Thanks

Vikas

anbu1984 — Fri, 23 May 2014 06:01:38 GMT

Do you have single row with Max Date in table "QLIKVIEW_SIM_DB".dbo.MAXDT?

anbu1984 — Fri, 23 May 2014 06:05:53 GMT

Try this

Where DivTarDate <= date('$(vMaxDate)','DD/MM/YYYY') ;

vikasmahajan — Fri, 23 May 2014 06:07:26 GMT

single row