topic Re: Getfieldselections in Script Load Statemanet in QlikView

Getfieldselections in Script Load Statemanet

Wed, 13 May 2015 23:38:02 GMT

Hi, I have an inline table (SelectCustomer), which i use a MultiBox to select different customer, than i create a variable (VSelectCustomer) which uses Getfieldselections from SelectCustomer to store the selection. Now i need to use the information from VSelectCustomer to use a IF LOAD in the script like the one below:

IF wildmatch('*VIVO*','$(VSelectCustomer)') then
SITES:
LOAD
.....
ENDIF

The problem is that in the ScripLoad the variable VSelectCustomer does not shows it selection from SelectCustomer, shows only the code =getfieldselections(SelectCustomer) .
There is any way to make the LOAD Scrip read the selection?

I already try change the '$(VSelectCustomer)' with $(VSelectCustomer) and just VSelectCustomer, and in all cases it returns the code ( =getfieldselections(SelectCustomer)) and not the values from the selection.

Re: Getfieldselections in Script Load Statemanet

JonnyPoole — Thu, 14 May 2015 02:42:28 GMT

I'm not sure i agree that this is possible.

If the variable values are static... then they should be accessible in the script.

But when the script is running, the data model is in the process of being flushed and renewed. An expression based variable should not really be able to be calcualted on a complete data model . The exception is if the expression is a valid script expression... in which case its calculated based on the script context

I'm trying to think how you can make the saved selection accessible to the script ... but i can't think of one.

Re: Getfieldselections in Script Load Statemanet

Thu, 14 May 2015 12:54:50 GMT

I was using before an input box to get the value to the variable and it was working OK in the Script. Now i changed to MultiBox, so i can use the MultiSelection feature, and add the value to the variable by getfieldselections. Seams that formulas in the variable do not work in the Script. Do you know any way to read a MuiltSelection from a field and use the result in the Script? BR

Re: Getfieldselections in Script Load Statemanet

Thu, 14 May 2015 19:53:58 GMT

Just found a Solution in the link below. Getfieldselections direct in the variable do not work in the LOAD script, but with Triggers it works! https://community.qlik.com/thread/65816