Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview does not recognise Direct Discovery Syntax

I tried to use the Direct Discovery Method under QlikView 11.2 with the following syntax:

ODBC CONNECT32 TO [MS Access Database;DBQ=\\ksafsp01\KSAGDAT\IT\01_Alle\001_Projekte\610_SmartScanning\Abgespeicherte_Dokumente.accdb];

Direct QUERY

DIMENSION

Lieferscheinnummer

MEASURE

Datum

FROM tblUnterschriebene_Speditionsaufträge;

I looked through several forum-entries and tried it with different databases without success.

Qlikview somehow does not recognise the Syntax because "DIRECT" becomes blue but "QUERY" not.

I am using QlikView Private edition version 11.2. Is this the problem? Furthermore, when opening a qlikview file, I have a choice between two qlikview versions:

Both versions do not succeed with the direct query syntax.

1 Reply
swuehl
MVP
MVP

I think the DIRECT QUERY syntax was introduced in a version later than 11.20 IR, AFAIR, DIRECT SELECT was used before that. There were also other syntax changes at that time.

To make it short, I would recommend to use a recent version of QV (11.20 IR is years old, and I don't want to talk about 11.00 SR1...)