Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

xufei123
Valued Contributor

how to load SQL Functions into Sense?

Can anyone help me with this please?

I have had a look at this discussion at Call a function in SQL LOAD but still don't understand.

I would like to use an example so if I have a SQL function called v_PNL, how can I load the data into Sense? What is the script in Sense data load editor?

v_PNL (@nmonth int, @year int, @lastYear int)

SELECT * from v_PNL (11, 2017, 2016)

 

Thank you very much!

Cheers

Fei

1 Solution

Accepted Solutions
xufei123
Valued Contributor

Re: how to load SQL Functions into Sense?

My colleague has figured it out.

The script should be:

SQL Select * from Databasename.dbo.FunctionName (variable1, variable2);

1 Reply
xufei123
Valued Contributor

Re: how to load SQL Functions into Sense?

My colleague has figured it out.

The script should be:

SQL Select * from Databasename.dbo.FunctionName (variable1, variable2);