Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How import/call function from PostgreSQL to QV

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 ?

2 Replies
Not applicable
Author

I was do it, thanks

kalyandg
Partner - Creator III
Partner - Creator III

hi claudia briano,

shall i get the code, in QV?