topic Re: Where statement in Direct Discovery in QlikView

Where statement in Direct Discovery

Anonymous — Fri, 13 Feb 2015 16:11:07 GMT

Hi,

I'm testing Direct Discovery and I'm trying to use 'WHERE' statement in my Direct Query but it doesn't work.

I have a date field and I want to obtain only the data that belongs to year 2014. So I did that:

DIRECT QUERY

DIMENSION

Customer,

Date,

Salesman,

Shop

NATIVE('CAST (EAN as nvarchar(30))') as EAN

MEASURE

UDS,

Amount

FROM GRP.dbo.Sales

WHERE Year(Date) = 2014;

I tried to use NATIVE statement: WHERE NATIVE('Year(Date)') = 2014; without success.

I found a workaround WHERE Date >= '01/01/2014' and Date <= '31/12/2014' but I'm interested to do it with qlik functions.

Some help?

Thanks

Re: Where statement in Direct Discovery

agomes1971 — Fri, 13 Feb 2015 16:40:26 GMT

Hi,

see this thread

http://community.qlik.com/thread/111959

HTH

André Gomes

Re: Where statement in Direct Discovery

Oleg_Troyansky — Fri, 13 Feb 2015 16:45:31 GMT

Keep in mind that the DIRECT QUERY statement is in essence a SQL SELECT statement that needs to be performed on the database. For this reason, it can't possibly use Qlik functions like Year() - you have to stay within the SQL syntax.

Re: Where statement in Direct Discovery

Anonymous — Fri, 13 Feb 2015 17:33:04 GMT

Thank to both of you for your answers.