Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Shouldn't be a problem if you have ODBC connection up.
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
Shouldn't be a problem if you have ODBC connection up.
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