topic Re: Store Procedure in QlikView

Store Procedure

prma7799 — Mon, 15 Dec 2014 06:06:23 GMT

Hi All,

How to write Store Procedure in QlikView.

Need some example to do practice.

Thanks

Re: Store Procedure

rajeshvaswani77 — Mon, 15 Dec 2014 06:08:48 GMT

Hi,

You cannot write a stored procedure in QlikView.

Please check out basics on QlikView and its usage.

thanks,

Rajesh Vaswani

Re: Store Procedure

amit_saini — Mon, 15 Dec 2014 06:10:58 GMT

Hi Prashant,

Did u mean something like below:

projects:

LOAD id as project_id,

`continent_id`,

`country_id`,

`branch_id`,

`region_id`,

`agency_id`,

name as project_name,

description,

active as project_active,

status as project_status,

account,

type,

`is_deleted` as project_is_deleted;

SQL SELECT *

FROM `ciweb_denc_qlikview`.projects WHERE is_deleted="0";

Store [projects] into ..\QVD\projects.qvd(qvd);

Drop Table [projects];

Thanks,

Re: Store Procedure

its_anandrjs — Mon, 15 Dec 2014 06:16:42 GMT

You have mean for QVD store or the SQL Store procedure in Qlikview.

For store procedure you can read it in the qlikview not write in the qlikview see this post

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

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

Ex:-

Table:

load *;

SQL execute SP_Proc ....';

An For QVD Store

Ex:-

Table:

Load * from Source;

Store Table into Table.qvd;

Regards

Anand

Re: Store Procedure

Anonymous — Fri, 13 Mar 2015 08:01:37 GMT

Hi,
You can't write Stored Procedures in QlikView, but you can call stroed procedures from qlik view
Follow the link to know more; http://community.qlik.com/message/393826#393826