variable date with where clause in loading Qv

[vikasmahajan]

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]

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

[anbu1984 · Accepted solution]

Try this

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

[vikasmahajan]

single row