Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to write stored procedure in QlikView?

Friends,

Can we write stored procedure in QlikView? If then where we have to write the procedure?

And how to call the procedure from the qlikview script (OR) do we have have any other default option to do procedure.

Please help me .

Thank you,

Thiru.

2 Replies
israrkhan
Valued Contributor II

Re: How to write stored procedure in QlikView?

Hi,

we cant write Store Procedure in qlikview, but we can execute(call)store procedure in qlik view.

how to execute ,see the link below

http://community.qlik.com/message/203397#203397

Hope it helps...

MVP
MVP

Re: How to write stored procedure in QlikView?

Hi,

Qlikview is not used to create  stored procedure, it is used to fetch data from database using query or stored procedure.  We can call using stored procedure like this

TableName:

Load

Field1

Field2

...

;

Sql Exec StoredProcedureName 'Variable1', 'Variable2';

http://community.qlik.com/message/362378#362378

http://community.qlik.com/message/264515#264515

Regards,

Jagan.

Community Browser