Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading Variables as Strings in Load Script

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?

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

3 Replies
giakoum
Partner - Master II
Partner - Master II

It should work (see attached).

Maybe you could upload a sample application.

vincent_ardiet
Specialist
Specialist

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

Not applicable
Author

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