Store/ Capture particular selection in sheet objects

Tue, 15 Jan 2013 09:36:09 GMT

Hi,

I m having a list box and few sheet objects. Whenever i select a particular data from list box, i should be able to preserve it and use it in different expressions in the sheet object.

Is this possible.

Pls help me.

Regards,

Malathi

Re: Store/ Capture particular selection in sheet objects

Anonymous — Fri, 23 Aug 2013 12:46:12 GMT

Hi,

Yes, it is possible.

1. In your QV Client you just go to Settings -> Document Properties -> Triggers -> Field Event Triggers, select the field for which you need to Capture the selected value and 'Add Action' under the 'OnSelect' condition.

2. Click the 'Add' button in the new Actions window. Choose 'External' Action Type and 'Set Variable' Action.

Click OK to configure Variable details. Of course you need to have the variable already created/existing via the Document Settings -> Variables -> Add or Settings -> Variable Overview -> Add.

3. If you are not focused on the newly added 'Set Variable' Action you need to select it (click on it again). Because users may select more than one value in the target field you should actually 'concat' the selected values to make sure they are all captured correctly. Here is an example:

Click OK twice to get back to the dashboard.

4. Make selection(s) in the target field and open Settings -> Variables Overview. Your variable should contain a comma separated list of selected values.

Alternative approach is to use the GetCurrentSelections functions:

topic Store/ Capture particular selection in sheet objects in QlikView

Store/ Capture particular selection in sheet objects

Re: Store/ Capture particular selection in sheet objects