topic Re: Expression variable from UI to script in QlikView

Expression variable from UI to script

pauluk__ — Wed, 14 Dec 2016 16:21:56 GMT

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.

Re: Expression variable from UI to script

sunny_talwar — Wed, 14 Dec 2016 16:48:00 GMT

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.

Re: Expression variable from UI to script

pauluk__ — Wed, 14 Dec 2016 16:51:59 GMT

Great suggestion, I'll give it a go.

Re: Expression variable from UI to script

pauluk__ — Wed, 14 Dec 2016 16:59:10 GMT

This has worked. Thank you very much.

Re: Expression variable from UI to script

sunny_talwar — Wed, 14 Dec 2016 17:00:19 GMT

Awesome, I am glad it did