How import/call function from PostgreSQL to QV

Tue, 12 Jun 2012 20:14:09 GMT

I have a problem with function from my DB in PostgreSQL, I need call or import the function but ONLY appear the TABLES when I try select it.

I need something like that:

SQL (

SELECT IO.DOCUMENTNO AS DOCUMENT,

FUNCTION_DB(IOLINE.M_PRODUCT_ID, IO.MOVEMENTDATE, 'AV') AS TOTAL

FROM IO LEFT JOIN IOLINE ON IO.TABLE_IO_ID = IOLINE.TABLE_IO_ID

)

How can I do this when I am loading the tables in QlikView ?

Re: How import/call function from PostgreSQL to QV

Thu, 14 Jun 2012 17:14:00 GMT

I was do it, thanks

kalyandg — Thu, 12 Jun 2014 10:26:02 GMT

hi claudia briano,

shall i get the code, in QV?