topic variables in qvd-Files? in QlikView

variables in qvd-Files?

swegener — Tue, 03 Nov 2009 21:19:03 GMT

Is it possible to store variables in qvd-Files in order to read their values later?
How could that be accomplished?

variables in qvd-Files?

prieper — Wed, 04 Nov 2009 02:19:52 GMT

Why not?

Should be a script like the below (not tested):

LET sMyVariable = 'TEST';
VarTable: LOAD $(sMyVariable) AS TableField AUTOGENERATE 1;
STORE VarTable INTO .\VarTable.qvd;

HTH
Peter

variables in qvd-Files?

Wed, 04 Nov 2009 02:26:08 GMT

And when you want to read that information you can use either


peek(TableField,0)
or
FieldValue(TableField,1)

Those should return the field value so you can use it.

variables in qvd-Files?

Wed, 04 Nov 2009 02:43:33 GMT

And maybe you could create a qvd with variable name and variable value.

In this case you could have more than one variable in your qvd file...

After when you load it you do a loop to retrieve all variables names and values...

To test, but I think that should work...

No I don't have an example for the time being, But I will try that tomorrow...

variables in qvd-Files?

Wed, 04 Nov 2009 03:35:26 GMT

Finally I did it,

In this example variables are loaded from an inline table, but from a qvd this is the same:

tables_variables:
LOAD * INLINE [
Variable_name, Variable_value
asterix, smart
obelix, big
idefix, fast
];

for i=0 to noofrows('tables_variables')-1
LET var_name= peek('Variable_name',i,'tables_variables');
LET $(var_name) = peek('Variable_value',i,'tables_variables');
next i

Just reload and ... Tada ...

variables in qvd-Files?

swegener — Wed, 04 Nov 2009 17:07:41 GMT

Thanks for your solutions. They will help me to solve the problem. But they also show me that there seems to be no way to just copy variables and their values from a qvw-File to a qvd-File and from there to another qvw-File. I will have to convert variables into internal tables.

Greetings,

S. Wegener