topic Re: filer data based on date filter in QlikView

filer data based on date filter

anuradhaa — Mon, 18 Jan 2016 15:33:47 GMT

Hi,

See attached.

Here i want to import data which has "Accepted at" in 2011.

sunny_talwar — Mon, 18 Jan 2016 15:35:58 GMT

Just responded to your previous post also. May be this:

SET DateFormat='D-MMM-YY';

Table:

LOAD Id,

[Created at],

[Accepted at]

FROM

testcsv.xlsx

(ooxml, embedded labels, table is Sheet1)

Where [Accepted at] > MakeDate(2011, 1, 1);

Mon, 18 Jan 2016 15:48:03 GMT

Also this might work,

it's similar to the above example but you dont have to change the date format (if for some reason thats necesary)

LOAD Id,

[Created at],

[Accepted at]

FROM

testcsv.csv

(txt, codepage is 1255, embedded labels, delimiter is ',', msq)

Where Year(date#([Created at], 'DD-MMM-YY')) = 2011;