Store Procedure

[prma7799]

Hi All,

How to write Store Procedure in QlikView.

Need some example to do practice.

Thanks

[rajeshvaswani77]

Hi,

You cannot write a stored procedure in QlikView.

Please check out basics on QlikView and its usage.

thanks,

Rajesh Vaswani

[amit_saini]

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,

AS

[its_anandrjs]

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

[Anonymous]

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