Syntax where in qvd load not working

[#1]

Hi All,

Please give me help about this syntax :

Load

     Bulan

     ,Tanggal

     ,Tahun

FROM

[..\QVD\QvComp.qvd]

(qvd)

Where Date(Date#(Bulan & '/' & Tanggal & '/' & Tahun, 'M/D/YYYY')) <= Date(Date#('$(V_PERIODCLOSE)', 'M/D/YYYY'));

Why the where condition is not working ?

Did I mistake something ?

Thank you all

[omkarvamsi]

if you get the result,Please close the thread " as answered"

Qlik Community Tip: Marking Replies as Correct or Helpful

[#3]

Hi Omkar,

I have try :

where num(Date(MakeDate(yyyy,m,d),'YYYY-MM-DD'))<=$(V_PERIODCLOSE);

and

where num(Date(MakeDate(yyyy,m,d),'DD/MM/YYYY'))<=Date($(V_PERIODCLOSE),'DD/MM/YYYY');

The condition is :

- V_PERIODCLOSE = 2016-11-30

- I have change for column = yyyy (2017 --> 2016) in SampleData.xlsx

I have run for that condition, and the result :

QvCompoundingOracle << Sheet1 0 lines fetched

That not right.

But the strange is, when I have change "where condition < with > " :

where num(Date(MakeDate(yyyy,m,d),'YYYY-MM-DD'))>=$(V_PERIODCLOSE);

The result :

QvCompoundingOracle << Sheet1 7 lines fetched

[omkarvamsi · Accepted solution]

please make sure the date in variable $(V_PERIODCLOSE) is in num format.

if it is not,

you can convert like this as below

LET V_PERIODCLOSE= num(Date([Date field]));

[#5]

Hi Omkar,

That's work.

Conclusion : the date filter is more easy if we use num.

Thank you very much

[omkarvamsi]

Please mark questioned as answered.

thank you