Discussion board where members can get started with Qlik Sense.
I am loading data from QVD with the following syntax. The issue is ORDER_DATE fetching data even from 2006 inspite I kept a where clause to bring only from 2009-Oct-01. Kindly help
Date(ORDER_DATE) as ORDER_DATE,
FROM [lib://QVDs (bi_administrator)/SALES_ORDER_HEADER.QVD]
WHERE ORDER_DATE >= Num(Date(01-10-2009, 'DD-MM-YYYY'));
Go to Solution.
Thanks for stepping into my rescue. I found that issue is with Date function "Date(01-10-2009, 'DD-MM-YYYY')" , when I changed it to Date#('01-10-2009', 'DD-MM-YYYY') things are okay.
Try with Floor
WHERE floor(ORDER_DATE) >= Num(Date(01-10-2009, 'DD-MM-YYYY'));