Skip to main content

GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JGMDataAnalysis
Creator II
Creator II

ST_AsText Function Error | Qlik Sense May 2021 Patch 2 | ODBC

Hello, how are you?

When using the PostGIS function ST_AsText in a query I get the following error:

JGMDataAnalysis_1-1644282663346.png

However, when I run the same query using the DBMS interface, it runs successfully.

It should be noted that the same data was used for both connections, Qlik and DBMS, respectively.

SELECT version():

PostgreSQL 11.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit

JGMDataAnalysis_0-1644282579319.png

@Patric_Nordstrom can you guide me?

Labels (2)
2 Replies
Patric_Nordstrom
Employee
Employee

Should work

See connector example (for SQL server but same principle)

https://community.qlik.com/t5/Qlik-Sense-Documents/MS-SQL-Server-and-Qlik-GeoAnalytics-QGA/ta-p/1521...

 

Thanks,

Patric

JGMDataAnalysis
Creator II
Creator II
Author

Thank you very much, Patric. I'm going to try installing the QGA Plus connector that allows me to pass the SELECT statement directly to it.