Discussion Board for collaboration related to QlikView App Development.
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
Can you try putting Test within double quotes:
DIRECT QUERY
DIMENSION
1 As Flag
MEASURE
col1,
col3,
col4
From "Test";
Can you try putting Test within double quotes:
DIRECT QUERY
DIMENSION
1 As Flag
MEASURE
col1,
col3,
col4
From "Test";
Any idea, regarding "How can we create Straight Table using Direct Discovery"
I have responded to the new thread that you have created
ok, thanks...I will check