Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ianlapid
New Contributor

QVD WHERE clause?

I cant seem to get this to work?

LET v_Load_Before_date = Date#('2018-07-02');

temp_shift_duration:

LOAD

    batch_id,

    shift_date

FROM [$(vLibPath)$(vQVD_Name).qvd](qvd)

WHERE shift_date < $(v_Load_Before_date);

I suspect this: shift_date < $(v_Load_Before_date), doesn't really work?

Thank you in advance!

Tags (1)
1 Reply
francescoreggia
New Contributor III

Re: QVD WHERE clause?

Try

Date#(shift_date)< $(v_Load_Before_date)

Community Browser