QSL oracle to Qlikview

[bsbernabe]

Hello There,

I had another concern loading data to Qlikview, but before I create a query using at Oracle SQL  then now I need to do this in Qlikview.

Below is script created at SLQ Oracle

select to_char(Rdtl_sale_RPT(A.AGREEID,'L'),999999990.99) "PN ",
to_char(Rdtl_sale_RPT(A.AGREEID,'P'),999999990.99) "Total",
C.CUSTOMERNAME "BP Name"
from LBS_AGREE_DTL A.
CUSTOMER_M C

Any suggestions will be much appreciated!

Best Regards,

Bing

[Arthur_Fong · Accepted solution]

Shouldn't be a problem if you have ODBC connection up.

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Oracle...

Script:

load *;

select to_char(Rdtl_sale_RPT(A.AGREEID,'L'),999999990.99) "PN ",
to_char(Rdtl_sale_RPT(A.AGREEID,'P'),999999990.99) "Total",
C.CUSTOMERNAME "BP Name"
from LBS_AGREE_DTL A.
CUSTOMER_M C