topic Re: Stored Procedure/Macro in QlikView

Stored Procedure/Macro

Anonymous — Wed, 05 Nov 2014 11:49:26 GMT

Hi guys,

Is it possible to execute a stored procedure with a variable via a button within a document? I've been trying to do this via a macro button but I can't figure this out

Thanks!

Re: Stored Procedure/Macro

Wed, 05 Nov 2014 13:33:05 GMT

Hi,

I tried to do so and it run successfully.

This is what I did-

1.Created a variable vdemo and set it's value to 0

2.Created a button and allow it to change the value of variable(vdemo) to 1 using action on it.

3.Go to document properties and go to variable event triggers and apply action to run macro on changing value of variable.

4. Click on button and check value of variable, it will change to yes(as my macro is changing it)

It seems like this is the only way I know.

Attaching the required snapshots.

Cheers

Saurabh

Re: Stored Procedure/Macro

Anonymous — Fri, 07 Nov 2014 17:00:17 GMT

Hi Saurabh,

Thanks very much for your help.

Would you be able to post a sample QVW file with these steps in please?

That would be a great help

Re: Stored Procedure/Macro

Anonymous — Fri, 07 Nov 2014 17:05:53 GMT

Also i cannot see that your macro is running a stored procudure? Would you be able to help with this as getting the macro to run the stored procedure is where i am struggling..

thanks!