topic Re: Remove Data by Date in script in QlikView

Remove Data by Date in script

slribeiro — Mon, 30 Nov 2015 16:52:18 GMT

Greetings, i'm new at this and would be amasing if you could help me.

I have one table like the following:

Name, Value, Date

A1, 3, 06-03-2015

A2, 2, 07-03-2015

A3, 6, 15-03-2015

A4, 4, 01-03-2015

How do i remove the data after 10-03-2015 in script?

I want to define a data in a variable and in this example have a final table like this:

Name, Value, Date

A1, 3, 06-03-2015

A2, 2, 07-03-2015

A4, 4, 01-03-2015

Best regards

Simão Ribeiro

swuehl — Mon, 30 Nov 2015 17:36:29 GMT

Set DateFormat = 'DD-MM-YYYY';

Let vDate = Num(MakeDate(2015,3,10));

LOAD Name, Value, Date

FROM YourDataSource

WHERE Date <= $(vDate);

engishfaque — Tue, 01 Dec 2015 09:36:35 GMT

Dear Simao,

Kindly find attached document, I hope you are looking for that one.

Kind regards,

Ishfaque Ahmed