Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
robert_mika
Master III
Master III

Evaluate variable in script

I'm trying to look at a table from variable

My set-up

Languages:

Load * Inline [

Language

EN,

AL,

]

;

Tansalation:

LOAD

    ID,

    EN,

    AL

FROM

[..\Config\For Translation.xls]

(biff, embedded labels, table is UniqueObjectID$);

My Expressions in GUI are

vLanguage:

=chr(39)& Language& chr(39)

then for each field:

=fieldvalue($(vLanguage),25)

Which is looking at the table with translation and picking up the right field.

So I will wrap this

LET vHITS:fieldvalue($(vLanguage),25)

so the evaluation will take place at script level?

I'm trying few option but  none is working.

The aim is to have all fields replace with variables from external sources

11 Replies
robert_mika
Master III
Master III
Author

Could you provide an example of your first suggestion?

You are right you can not pass GUI parameters to script probably that's why the vLanguage will not be evaluated.

My aim was to move  all expressions to qvd.

Is the a way to use somehow the IF statement to give the variable first language at script level and then when there is selection from listbox change the language.

The language I'm working on in nothing that QV supports.

So using SA table is not a option.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

To show you that a document UI can pass values to the script, see the attachment. It may be useful for your situation.

The document uses a listbox to control the reload. It does not control languiage selection in real-time.