topic Re: how to extract data using "date" filter in QlikView

how to extract data using "date" filter

Thu, 03 Dec 2015 12:28:33 GMT

FAX:

SQL SELECT

ID,

DATE,

ACCOUNTNAME,

DOCNAME,

PAGECOUNT,

DURATION,

PHONENUMBER

FROM DB."FAX";

store FAX into FAX.qvd (QVD);

loading from *.qvd is very easy

FAX:
Load
    ACCOUNTNAME,
     PAGECOUNT,
     DATE,
     year(DATE) as YEAR,
     MONTH(DATE) AS MONTH,
     Day(DATE) as DAY,
     MONTH(DATE) & year(DATE) as Mo_Ye

FROM [..\FAX.qvd]
(qvd);

======

DATE

Data_Type = SQL_Timestamp (11)

Type Name = Date

Column_Size =19

Buffer-Lengt =16

etc...

========

because of a very large amount of data, extracting without filtering by year is very difficult and time consumption.

please help me to find out a solution:

"where year(date)=2015" =YEAR: invalid identifier

"where year[(date)=2015] " =invalid relational operator

"where date(trxdate)=31/12/2014" =missing expression

Re: how to extract data using "date" filter

Anonymous — Thu, 03 Dec 2015 12:38:45 GMT

try this:

FAX:
Load
    ACCOUNTNAME,
     PAGECOUNT,
     DATE,
     year(DATE) as YEAR,
     MONTH(DATE) AS MONTH,
     Day(DATE) as DAY,
     MONTH(DATE) & year(DATE) as Mo_Ye

FROM [..\FAX.qvd]
(qvd) where year(DATE)=2015;

Re: how to extract data using "date" filter

Thu, 03 Dec 2015 13:09:01 GMT

Thank you very much!

but I want to filter data from the beginning, not after I store them in FAX.QVD and load from...

ODBC CONNECT TO[..... ] (UserId is..., Password is ...);

FAX:

SQL SELECT

DATE,

...

FROM DB."FAX";

store FAX into FAX.qvd (QVD);

Re: how to extract data using "date" filter

Anonymous — Thu, 03 Dec 2015 13:14:02 GMT

In case of Date, try this:

FAX:
Load
    ACCOUNTNAME,
     PAGECOUNT,
     DATE,
     year(DATE) as YEAR,
     MONTH(DATE) AS MONTH,
     Day(DATE) as DAY,
     MONTH(DATE) & year(DATE) as Mo_Ye

FROM [..\FAX.qvd]
(qvd) where date(DATE,'DD/MM/YYYY')='31/12/2014';

Re: how to extract data using "date" filter

Thu, 03 Dec 2015 13:26:14 GMT

missing expression

Re: how to extract data using "date" filter

Thu, 03 Dec 2015 13:46:29 GMT

I need data filter from the beginning not after I load from FAX.QVD

ODBC CONNECT TO[..... ] (UserId is..., Password is ...);

FAX:

SQL SELECT

DATE,

..........................

FROM DB."FAX";

store...