Qlikview does not recognise Direct Discovery Syntax

Tue, 04 Jul 2017 15:00:52 GMT

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.

Re: Qlikview does not recognise Direct Discovery Syntax

swuehl — Tue, 04 Jul 2017 20:39:59 GMT

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...)

topic Qlikview does not recognise Direct Discovery Syntax in QlikView

Qlikview does not recognise Direct Discovery Syntax

Re: Qlikview does not recognise Direct Discovery Syntax