Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

somenathroy
Contributor III

Issue to run Direct Query in Qlik Sense June 2017

Hi All,

I am trying to connect Greenplum database by using DIRECT QUERY.  The below error message is generating.

ddq.PNG

Have written the below DIRECT QUERY:

Fact:

DIRECT QUERY

DIMENSION

<field1>

MEASURE

<field2>

FROM <schema_name>.<table_name>;

But data is pulled successfully with the below select SQL:

SQL Select

<field1>,

<field2>

from <schema_name>.<table_name>;


Does not Greenplum source support Direct Discovery ? Or Am I missing something?

Thanks,

Som

2 Replies
shraddha_g
Honored Contributor III

Re: Issue to run Direct Query in Qlik Sense June 2017

Was that working with previous version?

somenathroy
Contributor III

Re: Issue to run Direct Query in Qlik Sense June 2017

I am trying Dierct Query with QS June 2017 version only.