topic Re: Store variables into QV Server through access point (AJAX) in QlikView

Store variables into QV Server through access point (AJAX)

Tue, 23 Dec 2014 09:38:02 GMT

Dear All,

I've got 3 variables in a QV document, and I want to write it back into the QV server and stored as csv file. Users need to access it through both Desktop Client & AJAX.

Currently I can use Marco or Partial reload to implement it for desktop access while I don't know how to do it through access point (AJAX). Can anyone help me?

Re: Store variables into QV Server through access point (AJAX)

Mon, 29 Dec 2014 14:58:45 GMT

This is a macro method:http://community.qlik.com/message/319137#319137

How can I do it for AJAX?

Re: Store variables into QV Server through access point (AJAX)

jagan — Tue, 30 Dec 2014 06:11:53 GMT

Hi,

We can do this only by using macros, but macros won't work in Ajax. I am not sure why you are looking to write back? Instead you can write back in next reload using below script

TableName:

LOAD

$(variable1) AS Var1,

$(variable2) AS Var2,

$(variable3) AS Var3

AutoGenerate(1);

STORE TableName INTO FileName.csv (txt);

Hope this helps you.

Regards,

jagan.

Re: Store variables into QV Server through access point (AJAX)

Tue, 30 Dec 2014 12:24:07 GMT

Hello Jagan,

Thanks for your reply. That's what I did to the script, while QVW in Ajax will restore the value in the input box to the initial one after document reloading.

The reason why I want to write back is because there're a bunch of variables that values can be changed. And we need to use the mobile client.

In the desktop client, variables' values are saved then reload

In the IE plugin, it support Macro to export.

However, I've tried lots of approaches, all can't work in the Ajax client.

Do you have other ideas about it if not writing back data?

Thanks.

Alan

Re: Store variables into QV Server through access point (AJAX)

jagan — Wed, 31 Dec 2014 17:16:56 GMT

Hi,

I think you can check for EDX triggers.

Regards,

Jagan.