Fetch Data Using Direct Discovery from view

[Anonymous]

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,

MK

[sunny_talwar · Accepted solution]

Can you try putting Test within double quotes:

DIRECT QUERY

DIMENSION

  1 As Flag

MEASURE

  col1,

  col3,

  col4

From "Test";

[Anonymous]

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

[sunny_talwar]

I have responded to the new thread that you have created

[Anonymous]

ok, thanks...I will check