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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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?