topic Re: Where clause in direct discovery in QlikView

Where clause in direct discovery

omid5ive — Sat, 03 Jun 2017 08:59:23 GMT

i have below query and i need to use it in direct dicovery

--------------------------------------

DIRECT QUERY

dimension

ACOUNT_NUMBER,

REMDEPDATE,

MEASURE

REMDEP

FROM GHR_TA_CLOSE_BALANCE a

WHERE A.SANAD_DATE_NO = (SELECT MAX (A.SANAD_DATE_NO)

FROM GHR_TA_CLOSE_BALANCE a)

------------------------------------------------------------------------------------

when i reload this query i get attached error

how can i sole it?

Re: Where clause in direct discovery

SteveNewman — Sat, 03 Jun 2017 13:33:27 GMT

‌"direct" is a key word and so you should not use it to name the table. Instead try something like ...

direct_query:

DIRECT QUERY

DIMENSION

ACCOUNT_NUMBER,

...

Re: Where clause in direct discovery

Anil_Babu_Samineni — Tue, 06 Jun 2017 01:52:50 GMT

Remove Comma(,) from dimension syntax

Re: Where clause in direct discovery

omid5ive — Tue, 06 Jun 2017 05:32:22 GMT

i changed it but it does not fixed

Re: Where clause in direct discovery

omid5ive — Tue, 06 Jun 2017 05:32:29 GMT

i changed it but it does not fixed

Re: Where clause in direct discovery

Anil_Babu_Samineni — Tue, 06 Jun 2017 05:47:10 GMT

I assume, You need Nested Aggregation for all resident's.

Re: Where clause in direct discovery

omid5ive — Tue, 06 Jun 2017 06:12:12 GMT

can you send me an example?

Re: Where clause in direct discovery

Anil_Babu_Samineni — Tue, 06 Jun 2017 06:15:30 GMT

In fact, i never worked with Direct Query earlier. But, I've fetch few data set from different source, Let me think little more related the same. Then we can talk

Re: Where clause in direct discovery

omid5ive — Tue, 06 Jun 2017 06:19:18 GMT

thanks a lot

Re: Where clause in direct discovery

SteveNewman — Tue, 06 Jun 2017 11:39:15 GMT

What is the new error message?

Re: Where clause in direct discovery

omid5ive — Wed, 07 Jun 2017 07:33:55 GMT

no new message
No direct statement