Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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...
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.