topic Re: Read QV-Variables via JavaScript in QlikView

Read QV-Variables via JavaScript

Mon, 26 Jan 2026 16:26:21 GMT

Hello everybody,

my problem is: if I define a variable in the desktop client (for instance: vTest = localTime()) i'm not able to access the interpreted content of that variable in the Ajax-client. I just can read "localTime()" as a String from the VariableMgr. The idea is to send the function-name "localTime()" to the QV-Server via Ajax (or to use the QMS-WebService API) and get the interpreted value as a response. Is that possible? Or even better: I send the name of the variable ("vTest") to the QV-Server and get the calculated content.

I can't find proper methods in the QMS-API nor "JS-API" 😞

->Workaround: I could define input boxes dynamically via JS, access it, get the calculated content and remove the input box, but it's way too slow!

Can anybody help me out here?

Thanks in advance,

Lars

Read QV-Variables via JavaScript

jonathandienst — Mon, 07 May 2012 16:28:41 GMT

Lars

If you put a leading = in the variable definition, you should get the interpreted value in both Ajax and the local client. You can do this in the variable dialog, and in script you would say:

Set vTest = =localtime(); // that's not a misprint

Then use it in expressions as $(vTest) or '$(vTest)'.

Hope that helps

Jonathan

Read QV-Variables via JavaScript

Tue, 08 May 2012 07:44:40 GMT

Hello Jonathan,

thanks for your reply!

Unfortunately it's not working. Let me explain you my intention in more detail:

I am able to define variables and I can use them in expressions. But I can't use them in the JS-Code of an extension object. In pseudo-code i want to do sth like this:

Qva.AddExtension(..., function(){

var vTest = QlikView.giveMeTheInterpretedVariable("vTest");

alert(vTest); // displays "08.05.2012 09:43:45"

},false);

Is there a functionality like this? Or some workaround?

Thanks + best regards,

Lars

Read QV-Variables via JavaScript

ErikWetterberg — Tue, 08 May 2012 09:20:42 GMT

Hi Lars,

One way is to use the Text tag in your Definition.xml:

In the property dialog, set it up like '=vTest'.

You extension will get the value in Layout.Text0.text (if it is your fist Text tag).

Alternatively you can set the variable name in the Definition.xml:

There is also a javascript call to get all variables:

Qv.GetDocument("").GetAllVariables(callback);

where callback is a javascript function to handle the result.

Erik

Re: Read QV-Variables via JavaScript

Tue, 08 May 2012 09:44:09 GMT

Hi Erik,

you just made my day - that simple 🙂

Qv.GetDocument("")... worked.

Thank you very much!

Lars

Re: Read QV-Variables via JavaScript

Mon, 04 Jun 2012 14:45:27 GMT

Hi Eric (and everyone else),

at the first moment that solution seemed to work. But now it's not working anymore 😞
Is it possible that this is a bug in QV11SR1 (can't imagine though)?

My Steps once more in detail:

I have a QVW with the fields YEAR (such as "2012") and MONTH (such as "6").

I created a variable "vKeyDate" with the definition "=MakeDate(Year,Month)"

-> works fine within a textbox or an inputfield (output: "01.06.2012")

In my Script.js of the extension I created a JS function:

var doc = Qv.GetCurrentDocument();

doc.GetAllVariables(function(data){

$.each(data, function(i, object){

console.log(object);

});

The returned (relevant) object looks like this:
{

isconfig: "false",

isnum: "false",

isreserved: "false",

name: "vKeyDate",

text: "",

value: "=MakeDate(Year,Month)" // <-- I want this to be interpreted

}

Can you confirm that this steps should work in SR1?

Best Regards,
Lars

Re: Read QV-Variables via JavaScript

Alexander_Thor — Mon, 11 Jun 2012 09:03:05 GMT

I'm getting the same results.

Re: Read QV-Variables via JavaScript

Tue, 12 Jun 2012 12:21:21 GMT

Hi Alexander,

do you think that there is any solution for this? It's really a big problem for us right now 😞
I had a small e-mail conversation with Ingemar Carlo last week and he gave me the tip to try the SetOnUpdateComplete Function of the qv-document and call the GetAllVariables function inside. His assumption was that the variables are not yet calculated when they are fetched.

But that results in an infinite loop, because the GetVariable function triggers the OnUpdate event of the document.... I fixed it like this:

Qva.AddExtension('Variables', function(){

var doc = Qv.GetCurrentDocument();

var varsRetrieved = false;

doc.SetOnUpdateComplete(function(){

if(!varsRetrieved){

Qv.GetDocument("").GetAllVariables(function(variables){

for(var i = 0; i < variables.length; i++){

alert(variables.name + " = " + variables.value);

}

});

varsRetrieved = true;

}

});

}, false);

But in the end it's still not working, regardless of the moment the variables are fetched.

Nachricht geändert durch lars.bayer

Re: Read QV-Variables via JavaScript

Fri, 06 Jul 2012 12:04:30 GMT

Do you use the LET command (not the SET) in the script? It works for me if I creat an variable

Let vTest = Today();

I get 2012-07-06 in my java script

/Gustav

Re: Read QV-Variables via JavaScript

Fri, 06 Jul 2012 12:06:07 GMT

one more thing you prorbably have to put it last in your script, after det data is loaded.

Re: Read QV-Variables via JavaScript

Alexander_Thor — Tue, 10 Jul 2012 09:10:31 GMT

Yes if you use LET variables it will work since it will calculate during reload and store that value into the qvw.

But if you want runtime values it seems you are out of luck with QV11 SR1.

For example wrapping a function around a user input variable would get you

vMyVar = =Sum($(vMyVar2))

and not the actual calculated value back.