topic Script doesn't filter records when I try to filter by dates ? in QlikView

Script doesn't filter records when I try to filter by dates ?

Anonymous — Wed, 16 Jul 2014 18:12:23 GMT

Hello,

I''m trying to filter records that are older than jan 01 2013 in the script dynamically i.e. conceptually something like filter sale_date > = year(today()-1),

Let vMaxdate =Year (today);
table:

LOAD

*
FROM

[New folder\fact_SalesOrder_Line_Extracted.qvd]
(qvd

)
where year (sales_order_date) >= $(vMaxdate) -1;

exit script

;

My requirements are as follows:

I do not want to hard code 01/01/2013 in the script , it has to be dynamic.The dashboard shows data from this year and last year.

It has to be neat and elegant and has to be done in the script editor and not front end.

Balraj

Re: Script doesn't filter records when I try to filter by dates ?

VishalWaghole — Thu, 17 Jul 2014 05:25:30 GMT

Hi Balraj,

Try this logic, hope it works for you.

let vMinDate = AddYears(yearstart(Today()),-1)

LOAD *

FROM [New folder\fact_SalesOrder_Line_Extracted.qvd](qvd)

where sales_order_date >= $(vMinDate);

-- Regards,

Vishal Waghole

Re: Script doesn't filter records when I try to filter by dates ?

Anonymous — Thu, 17 Jul 2014 13:14:14 GMT

You are the man ! 🙂 Worked like a charm!