topic Re: Step required to call the proc/func from any object which written in QV Editor in QlikView

Step required to call the proc/func from any object which written in QV Editor

Thu, 10 Dec 2015 11:32:22 GMT

Hi Forums,

I had written the following code in Qlikview Editor which as follows:-

//Start Here

OLEDB

CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sales_user;Initial Catalog=dummdb;Data Source=dummv01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=xxxxxxxxx;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is ramramramram);

TAB1:
Sql Select * from dum_date;
Sub Proc_1

SQL insert into dum_date (fld1) values('C');
End sub;

//CALL Proc_1; [This one run fine]

//End here

When I call Proc_1 from the script editore it's work fine.

But I want to call Proc_1 from Command Button or Text Box object, ETC.

Can any body please provide me the solution.

Thanks

Re: Step required to call the proc/func from any object which written in QV Editor

marcus_sommer — Thu, 10 Dec 2015 12:42:50 GMT

It's not quite clear what do you want to do. But I think it's not possible in this way. If you want to query external data from the gui you could use Direct Discovery and if you want to write back into a database you should look here: https://community.qlik.com/search.jspa?q=write+back&type=document

- Marcus

Re: Step required to call the proc/func from any object which written in QV Editor

Thu, 10 Dec 2015 13:05:51 GMT

Hi Marcus,

Thanks for quick response.

Let me explain you my requirement.

The way we create the macro(As Function/Sub) in EDIT MODULE and then we call on verious trigger type such, as on open, on select any column or object, on close, etc.

Same way the function/proc/sub which I had created as Qlikview Editor as show above. I want to call same on trigger type such as on open, close, select any column, or object, ETC.

I hope you understand

Thanks

Re: Step required to call the proc/func from any object which written in QV Editor

marcus_sommer — Thu, 10 Dec 2015 13:17:28 GMT

Routines which are created within the script couldn't be called on the gui - you could only call macro-routines but the most things should be possible with them.

- Marcus

Re: Step required to call the proc/func from any object which written in QV Editor

Thu, 10 Dec 2015 13:25:18 GMT

I had created the macro in qvw which run's fine in desktop. But same QVW when I upload on server it doesn't work.

can you please let me know how I should configure it.

Thanks

Re: Step required to call the proc/func from any object which written in QV Editor

marcus_sommer — Thu, 10 Dec 2015 13:33:28 GMT

With the AJAX client macros won't work - with the IE plugin the most macros should work.

- Marcus

Re: Step required to call the proc/func from any object which written in QV Editor

Thu, 10 Dec 2015 13:51:05 GMT

I am new in this. Can you please help me to knew AJAX client and IE Plugin. I knew this much thatelp if macro run in qlikview desktop it should work in qlikview server as well. However which is not working

is it possible for you to send sample qvw file and help me to configure it in qlikview server.

Thanks

Re: Step required to call the proc/func from any object which written in QV Editor

marcus_sommer — Thu, 10 Dec 2015 13:57:19 GMT

Before going on, please read this: Macros are Bad and think are there really no other ways to get your solution?

- Marcus

Re: Step required to call the proc/func from any object which written in QV Editor

Thu, 10 Dec 2015 14:01:37 GMT

I knew it slow down the application. But for me it is very important. It will be great helpful if you can help me on this problem.

Thanks

Re: Step required to call the proc/func from any object which written in QV Editor

marcus_sommer — Thu, 10 Dec 2015 14:06:48 GMT

A possible slow-down isn't the main-fact why the use of macros should be considered carefully. What does your macro(s)?

- Marcus

Re: Step required to call the proc/func from any object which written in QV Editor

Thu, 10 Dec 2015 15:03:15 GMT

I want to update one record in sql table with the help of macro on click of particular object. So it is must for me.

Thanks

Re: Step required to call the proc/func from any object which written in QV Editor

marcus_sommer — Thu, 10 Dec 2015 17:00:36 GMT

The IE plugin needs to be installed by the appropriate users and requirred therefore windows as OS which meant that mobile devices like smartphones or tablets don't work as well as apple machines (unless VM or dual-boot). Further you need to enable macro-execution within the qmc (server/system/security) but it's not sure that you get such macros to work.

Also possible is to use AJAX with extensions like:

Data2Webservice Object Extension

SQL Writeback from QlikView extension object.

- Marcus

Re: Step required to call the proc/func from any object which written in QV Editor

Fri, 11 Dec 2015 08:00:14 GMT

Hi Marcus,

Thanks for response.

But I don't know which IE Plugin I have to install. Can you please let me know?

One more question.

Today when I open the qvw file there is one dialogue box has appeare's. of which screen shot is attached.

Can you please let me know how to enable the check box of

Always use this option for documents from this Qlikview Server

So, that I can tick it.

And then upload on the server. So, that macro migth run at server level as well. which may resolved my problem.

Thanks

Re: Step required to call the proc/func from any object which written in QV Editor

marcus_sommer — Fri, 11 Dec 2015 08:35:31 GMT

You should install the plugin-version which comes with your server-installation in ... YourDrive:\YourServerFolder\Server\QlikViewClients\QlikViewPlugin. That the last check-box "Always .." is disabled had security reasons but I don't know which option is excactly responsible for this - see here the security tabs in user- and document security.

- Marcus

Re: Step required to call the proc/func from any object which written in QV Editor

Fri, 11 Dec 2015 09:47:36 GMT

Hi Marcus,

Thanks of your suggession. FYI, "\YourServerFolder\Server\QlikViewClients\QlikViewPlugin" folder already there with

some files which inculdes following files as well:-

1. QvPluginSetup.exe

2. QVPluginWin8andUp.exe

Any some more suggession can you please give me. So, that I can achieve my goal.

Thanks

Re: Step required to call the proc/func from any object which written in QV Editor

marcus_sommer — Fri, 11 Dec 2015 10:31:32 GMT

It depends from the OS of the users. QvPluginSetup.exe is for Win XP/Vista/7 and QVPluginWin8andUp.exe for Win 8/8.1/10.

- Marcus