topic Re: Problem saving variables that contain GetFieldSelections in QlikView

Problem saving variables that contain GetFieldSelections

martyn_birzys — Thu, 25 Jun 2015 17:50:44 GMT

I have two list boxes where user can select single value, and an input box. I have variables that pick up values using GetFieldSelections. When script is reloaded, a table containing one row is created, which is then joined to existing table values. My problem is that variables which set values using GetFieldSelections come across as formula not as value, i.e. '=GetFieldSelections(UserName)', instead of 'John'.

I've tried different syntax but could not get it working, any idea why? The app attached.

Scenario:
Load
'$(vSelectedName)' as User,
'$(vSelectedPeriod)' as ScenarioDate,
'$(vInput)' as [My Variable]
AutoGenerate (1);


Scenario:
LOAD *
FROM
Scenario.qvd
(qvd);


STORE Scenario into Scenario.qvd (qvd);

Re: Problem saving variables that contain GetFieldSelections

sunny_talwar — Thu, 25 Jun 2015 18:17:20 GMT

Look at this post, Why variable with formula in script don't have the value , but the formula?‌, this should guide you in the right direction

Best,

Sunny

Re: Problem saving variables that contain GetFieldSelections

Thu, 25 Jun 2015 18:23:28 GMT

Hey, I guess trigger is the option for this.

Re: Problem saving variables that contain GetFieldSelections

martyn_birzys — Fri, 26 Jun 2015 10:05:43 GMT

Thanks for the link Sunny, it works using triggers.

For anyone who is new to triggers like me, go to Settings / Document Properties / Trigger tab. Select Document Event Trigger called OnAnySelect, click Edit Action and create SetVariable Action.

and then edit the script:

let vSelectedName = '$(vaSelectedName)';
let vSelectedPeriod = '$(vaSelectedPeriod)';




Scenario:
Load
'$(vSelectedName)' as User,
'$(vSelectedPeriod)' as ScenarioDate,
'$(vInput)' as [My Variable]
AutoGenerate (1);


Scenario:
LOAD *
FROM
Scenario.qvd
(qvd);


STORE Scenario into Scenario.qvd (qvd);

Final app attached.

NOTE: The SAVE button only works in QlikView Desktop environment, it does not work on Access Point. There may be ways of doing it, but it is sufficient for me to have it working in Desktop.

Re: Problem saving variables that contain GetFieldSelections

sunny_talwar — Fri, 26 Jun 2015 10:07:52 GMT

Not a problem, I am glad I was able to guide you in the right direction