topic oracle function to join with QV in QlikView

oracle function to join with QV

engr_farhanqadr — Fri, 13 Sep 2013 13:34:20 GMT

Folks,

I have a oracle function abc(code) which shows a count of manpower of a specific manager I have codes of manager in list box.

how can I pass and join this code in function and join them.

Thanks,

Farhan.

Re: oracle function to join with QV

rbecher — Fri, 13 Sep 2013 13:46:41 GMT

Hi,

you can use your Oracle function only in the Oracle SQL Select statement. But maybe you can adapt the code of this function to build a mapping table in QlikView.

- Ralf

Re: oracle function to join with QV

Anonymous — Fri, 13 Sep 2013 13:51:40 GMT

you must call your oracle function in the script.

connect to Oracle database.

sql select code, abc(code) from "table contening yours managers";