topic Re: Evaluate variable in script in QlikView

Evaluate variable in script

robert_mika — Mon, 07 Dec 2015 09:08:45 GMT

I'm trying to look at a table from variable

My set-up

Languages:

Load * Inline [

Language

EN,

AL,

]

;

Tansalation:

LOAD

ID,

EN,

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

Re: Evaluate variable in script

prieper — Mon, 07 Dec 2015 09:44:34 GMT

No, evalution will take place on the fly,

see the attached example

HTH Peter

Re: Evaluate variable in script

robert_mika — Mon, 07 Dec 2015 09:46:54 GMT

Thank Peter,

This is what I got so far.

So I assume there is no way to evaluate/lookup for the value at script level?

Re: Evaluate variable in script

saumyashah90 — Mon, 07 Dec 2015 09:49:38 GMT

Do this,

LOAD

ID,

EN,

FROM

[..\Config\For Translation.xls]

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

LET vHit1 = Num(Peek('ID', 0, 'x'));

LET vHit2= Num(Peek('ID', 1, 'x'));

you can use two different variables for the same

Re: Evaluate variable in script

marcus_sommer — Mon, 07 Dec 2015 09:49:43 GMT

I don't understand your aim and why - what is the benefit? Maybe a short example is helpful.

- Marcus

Re: Evaluate variable in script

Peter_Cammaert — Mon, 07 Dec 2015 10:01:13 GMT

If you want to do this at script level, check the Lookup() function. It will do exactly the same thing as your expression, but this time in the script. For example:

LET vHITS = Lookup('$(vLanguage)', 'ID', 25, 'Translation');

But like the other posters, I don't really understand what you're trying to accomplish.

Re: Evaluate variable in script

tresB — Mon, 07 Dec 2015 10:10:09 GMT

Not sure what you are trying. Evaluating variable (from GUI) in script? If so, instaed of assign the field selection in variable (using variable definition), try using trigger like in attached sample.

Re: Evaluate variable in script

robert_mika — Mon, 07 Dec 2015 10:25:01 GMT

Thank you all for the input.

I maybe have gone too far:

As this part '$(vLanguage)' must be evaluate before script finished:

looking at the language table and pick up the right value

and as no selection has been made yet

as we woudl do in GUI:

"EN " selected in List box , expression (fieldvalue($(vLanguage),25) evaluates to field from ID=25)

this is probably no way to do this.

Re: Evaluate variable in script

robert_mika — Mon, 07 Dec 2015 10:25:51 GMT

To put all variables as external sources.,

Re: Evaluate variable in script

Peter_Cammaert — Mon, 07 Dec 2015 10:37:53 GMT

Of course there is a way to do this. Make sure that every selection in your languages list box (always a single one I guess) sets a variable vLanguage. Variables will not be cleared if you reload your document so they can be used to pass parameters from the UI to your script. This is a way to load only one language in an otherwise multi-language document (for example by repetitively passing a parameter in the task definition and repeating the reload for every language available)

But it's still not clear what you are trying to accomplish. As far as I know, QV documents work best if they include every piece of information and data that an(y) end-user could possibly be interested in. Not by asking the user what he's up to and then reloading just that bit.

As an example of how this works in an extremely dyynamic way, you could store the preferred language of every user in the SA table, and let QV throw out all irrelevant languages by simple data reduction when the user opens the document.

Or are we on the wrong track here?

Re: Evaluate variable in script

robert_mika — Mon, 07 Dec 2015 11:23:30 GMT

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.

Re: Evaluate variable in script

Peter_Cammaert — Mon, 07 Dec 2015 13:03:00 GMT

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.