topic writing procedures in QlikView

writing procedures

engr_farhanqadr — Thu, 05 Sep 2013 11:29:10 GMT

Follks,

Can we write stored procedures and cursors like in SQL/oracle in Qlikview.

Re: writing procedures

Gysbert_Wassenaar — Thu, 05 Sep 2013 18:04:30 GMT

You can write subroutines in the script. These can be called in the script to execute whatever you coded into the subroutine. These subroutines are only available in the script. You can also create functions in vbscript or javascript in the macro editor. These can be used as functions in the script or in macro's. You can alse create subroutines in the macro editor. These can be called as macro's from actions assigned to buttons/textboxes or triggers. And you can create variables that contain expressions that calculate a value. These can be nested and parameterized as well so you can use them as a kind of functions.

There are no cursors in Qlikview. There's no need for them so they don't exist. You interact directly with data by making selections. The selections are applied realtime to the in-memory database. Any charts and listboxes are recalculated on the fly to reflect the change in selections.

Re: writing procedures

vikasmahajan — Fri, 06 Sep 2013 04:18:37 GMT

PFA

Hope helps you

Vikas

Re: writing procedures

Sat, 04 Jun 2016 13:39:07 GMT

Hi,

I am also facing issue in fetching stored procedure data in QlikView.

I have posted this in community at Fetching Oracle stored procedure data into QlikView FAILS.

Could you please take a look at it and help me out.

Thanks in advance.

Thank you,

Laxmaiah Chowdary