topic custom default (aka environment) variables ? in QlikView

custom default (aka environment) variables ?

Anonymous — Wed, 24 Nov 2010 16:29:06 GMT

Hi,

Is it possible to have custom default (aka environment) variables additionally in desktop QV? Meaning that these variables will be avilable by default in all documents like the number interpretation variables. Can I add my custom variables into the set of the "number interpretation" variables, so it would be inserted into load scripts by default?

I known that there is API function to import variables from a file. Bu I couldn't find how to have "default" macros that would be run at every document load/creation...It is diffrent but related problem, to have default VBscript function library....That apperently is the way to go. For each new QV file , manually add VBscript code to include extrenal VBscript file and ExecuteGlobal its content. It will provide custom VBS functions and variables(?)

Any suggestions/comments would be appreciated

Thanks

Vlad

custom default (aka environment) variables ?

marcel_olmo — Wed, 24 Nov 2010 17:34:26 GMT

Hey recently I've done something similar. I load an external excel full with variables and when you load them into a QV file, they turn into document variables.

Very useful to show/ hide stuff, or maybe customize the document. I'm currently using it to put financial variables of my customers.

Here's the link :

http://community.qlik.com/media/p/139678.aspx

I hope it helps!!

custom default (aka environment) variables ?

Anonymous — Wed, 24 Nov 2010 17:58:47 GMT

Marcel,

I can't open your document with my Persinal Edition. But I guess that you have some VBscrupt stuff that go though the loaded table and put field values into new variables via CreateVarable->SetContent API methods. Right? It is essentially I meant mentioning VBscript way. I couldn't find ImportVars that imported variables from text file in the QV10 API. But obviosly it is possible to replace it with VBscrip using CreateVarable->SetContent

Vlad

custom default (aka environment) variables ?

marcel_olmo — Fri, 26 Nov 2010 10:41:08 GMT

OK Vladimir, I'll show you how it works.

I have an excel sheet that has variables like this

variable, valor

var1 1

var2 0

var3 1

...

and inside the script of the QV document I do something like this :

(What I do is loading the excel in a table called "VariablesConfig" and then I do a peek() to get the name of the variable and their value and I put it into variables of the QV document).

VariablesConfig :

LOAD variable,
valor

FROM
[variablesConfig.xls]
(biff, embedded labels, table is Hoja1$);

Let vNroRegistros = NoOfRows('VariablesConfig');
For vI = 0 to (vNroRegistros - 1)
Let vNombre_Variable = Peek('variable',vI,'VariablesConfig');
Let [$(vNombre_Variable)] = Peek('valor',vI,'VariablesConfig');
Next

Hope it helps!!

Cheers!