Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

Store Procedure

Hi All,

How to write Store Procedure in QlikView.

Need some example to do practice.

Thanks

4 Replies
rajeshvaswani77
Specialist III
Specialist III

Hi,

You cannot write a stored procedure in QlikView.

Please check out basics on QlikView and its usage.

thanks,

Rajesh Vaswani

amit_saini
Master III
Master III

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

meet_purushu
Contributor III
Contributor III

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