topic Re: Fetch Data Using Direct Discovery from view in QlikView

Fetch Data Using Direct Discovery from view

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am using postgresql, and QlikView 12.

I have created a View as -

CREATE VIEW Test As

Select *

From

table1 a

join table2 b

on a.col1=b.col2;

When I try to run SQL simple query inside QlikView -

Select * from Test;

It works fine.

But I am trying to fetch the data from View as -

DIRECT QUERY

DIMENSION

1 As Flag

MEASURE

col1,

col3,

col4

From Test;

It says -

"SQL##f - SqlState: 42P01, ErrorCode: 7, ErrorMsg: ERROR: relation "Test" does not exist;

Error while executing the query".

Anyone having any idea on same.

Please Assist.

Thanks & Regards,

Re: Fetch Data Using Direct Discovery from view

sunny_talwar — Wed, 26 Oct 2016 10:29:53 GMT

Can you try putting Test within double quotes:

DIRECT QUERY

DIMENSION

1 As Flag

MEASURE

col1,

col3,

col4

From "Test";

Re: Fetch Data Using Direct Discovery from view

Anonymous — Wed, 26 Oct 2016 11:13:36 GMT

Any idea, regarding "How can we create Straight Table using Direct Discovery"

Re: Fetch Data Using Direct Discovery from view

sunny_talwar — Wed, 26 Oct 2016 11:15:41 GMT

I have responded to the new thread that you have created

Re: Fetch Data Using Direct Discovery from view

Anonymous — Wed, 26 Oct 2016 11:18:39 GMT

ok, thanks...I will check