topic Re: Loading Variables as Strings in Load Script in QlikView

Loading Variables as Strings in Load Script

Tue, 10 Jul 2012 11:26:16 GMT

Hi,

I am missing something in my syntax here: -

LOAD * INLINE [

ExpressionName, Expression

Test1, $(Variable1)

Test2, $(Variable2) / $(Variable1)

];

Basically My objective is to get Expression loaded in so I can dynamically pick the expression inthe front end, the actual expressions are big and unweildy so I am trying to avoid using them.

Any ideas?

Re: Loading Variables as Strings in Load Script

giakoum — Tue, 10 Jul 2012 11:38:26 GMT

It should work (see attached).

Maybe you could upload a sample application.

Re: Loading Variables as Strings in Load Script

vincent_ardiet — Tue, 10 Jul 2012 11:40:54 GMT

Hi,

I suppose that you want to have clearly the string $(Variable1) in your table and not the content of Variable1 ? That's it ?

If it's the case you should do something like that :

LOAD 'Test1' as ExpressionName, '$'&'(Variable1)' as Expression AutoGenerate 1 ;

LOAD 'Test2' as ExpressionName, '$'&'(Variable2) / $'&'(Variable1)' as Expression AutoGenerate 1 ;

Regards,

Vincent

Re: Loading Variables as Strings in Load Script

Tue, 10 Jul 2012 14:37:36 GMT

Dealt with in UI, just left the $ out of the load script and generated additional variables.