topic Re: using Macro excu Store Procedure in qlikview in QlikView

using Macro excu Store Procedure in qlikview

sunilkumarqv — Tue, 25 Feb 2014 05:51:14 GMT

sub Trigger

Set conn = CreateObject("ADODB.Connection")

Set rs = CreateObject("ADODB.Recordset")

' String connection

strConn = "Connection Name"

' Open the connection

conn.Open strConn

parameter1= date1

parameter2= date2

' Execute the stored procedure

sqlQuery = "EXEC [dbo].[GetDatename] '2013/11/1','2013/2/2','25' "

rs.Open sqlQuery, conn, adOpenForwardOnly

end sub

hic — Tue, 25 Feb 2014 07:10:31 GMT

It is not possible to use a macro to load data into QlikView. You should do it in the load script instead, using

SQL EXEC [dbo].[GetDatename] '2013/11/1','2013/2/2','25' ;

HIC

jagan — Tue, 25 Feb 2014 07:31:04 GMT

Hi Sunil,

Instead of macro try like this in Qlikview script, it returns the resultset and stores in a table

TableName:

SQL EXEC [dbo].[GetDatename] '2013/11/1','2013/2/2','25' ;

Hope this helps you.

Regards,

Jagan.