Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to bring in a function from Database

Hi,

I'm new to Qlikview and have worked majorly on other BI tools like SAP BO and Cognos.

Im my exisiting database I have a few Functions Written by myself to help code a few transactions directly. In BO I can directly call them in the universe (not sure how many are familiar with BO) and get them on to the report.

In Qlikview how do I call these functions in the script.

This is the example of the function I want to call

Function F_GETCHAR(id, code, date) is the function that i wrote in the Oracle DB.

Can someone please help me with this..

1 Reply
rustyfishbones
Master II
Master II

Hi Sneha,

Create the Functions as Variables and then import those variables into Qlikview via Excel.

Here is link to a YouTube video I created to show how to do this, http://youtu.be/xg8NKngDIAE

Regards

Alan