Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

pauluk__
New Contributor II

Expression variable from UI to script

Hi,

I'm trying to bring a variable, based on an expression that is dependent on UI selections, into the script after a user-requested reload.

The expression uses functions such as GetSelectedCount() and I need to pass this into the load script to be used in an ADD LOAD function, e.g.:

vVariable = If(GetSelectedCount(fieldA) = 1, fieldB, 0)

At this moment when I use the variable it just gives me the code used in the expression, but I need to be able to bring the evaluated result if possible.

Does anybody know how I can do this?

Thanks.

1 Solution

Accepted Solutions

Re: Expression variable from UI to script

May be instead of leaving this as an expression, may be trigger to save the value into vVariable and trigger can set off based on changed in selection in fieldA.

4 Replies

Re: Expression variable from UI to script

May be instead of leaving this as an expression, may be trigger to save the value into vVariable and trigger can set off based on changed in selection in fieldA.

pauluk__
New Contributor II

Re: Expression variable from UI to script

Great suggestion, I'll give it a go.

pauluk__
New Contributor II

Re: Expression variable from UI to script

This has worked. Thank you very much.

Re: Expression variable from UI to script

Awesome, I am glad it did

Community Browser