topic Re: How to store a field selection value from UI to backend script variable??? in QlikView

How to store a field selection value from UI to backend script variable???

chandu441 — Mon, 28 Nov 2016 11:20:00 GMT

Hi All,

I am facing typical requirement like,,,

user will select the value from "Year: ListBox from that I have to save the Year Selected value as a variable in script level. So that I can define PastYear Value.

LET vFPrevYear = vFYEAR - 1;

Same as like that I have to store Quarter Selected Values from list based on that I will get the values vPrevQtr & vPrevQtrYear.

IF vQuarter > 1 THEN

LET vPrevQtr = vQuarter1 - 1;

LET vPrevQtrYear = vFYEAR1;

ELSE

LET vPrevQtr = 4;

LET vPrevQtrYear = vFYEAR1 - 1;

END IF;

As of now i am saving the values from front end using "=GetFieldSelections(YEAR1)". but it is not getting me the output from script side.

Please suggest me a solution which will helpful for me.

Thanks all of you....

Re: How to store a field selection value from UI to backend script variable???

b_garside — Mon, 28 Nov 2016 16:25:17 GMT

Use Set Variable action for your Sheet trigger called OnLeaveSheet.

See below. Just add the desired value or field value that the variable needs.

Re: How to store a field selection value from UI to backend script variable???

chandu441 — Tue, 29 Nov 2016 11:44:24 GMT

Sorry your suggestion wont work for dynamically changing year value. So I created all the variables from UI Level only rather than Script Level. It works for my scenario.

Thanks