topic substitute on Selection in QlikView

substitute on Selection

Mon, 08 Mar 2010 12:15:03 GMT

I have created a report on manufactured finished items in relation to their components.

In the report i would like to make various substitutions:

for example when the user selects a component item i would like that item to be substituted into the FITEM field and show the components for that item. As shown by the image provided.

is this something that can be done with Qlikview, if yes how can i implement it into the code

substitute on Selection

Tue, 09 Mar 2010 15:16:01 GMT

does anyone have any ideas on this?

substitute on Selection

amars — Wed, 10 Mar 2010 08:08:59 GMT

Hi Pritanya,

For that either u will need to write a macro or go in field Document Properties -> Trigger -> Field Event Triggers

Select the CITEM and on Select event add three action's (if using qlikview 9) . 1. Get the Value of selection in a variable by using if GetSelectedCount(CITEM) = 1, GetFieldSelections(CITEM). Then 2. Clear CITEM Field 3. Set the FITEM to the Value of a Variable.

or u can simply write a macro to be run on the Field Selection.

With Regards

Amar

substitute on Selection

Wed, 10 Mar 2010 11:03:06 GMT

I am fairly new to qlikview 9. can you explain what actions will be associated with your suggestions, the only one i'm certain about is suggestion number 2

substitute on Selection

amars — Wed, 10 Mar 2010 11:52:48 GMT

For Selecting a different field with the same value that u have selected in another field u will need to store it. For that u will need to create a variable in Variable's Overview. Now to store the value in a variable u will need to go in Document Properties -> Triggers -> Field Event Triggers . Select the field on which u need to fire the trigger(same one which u r selecting) . Now in front of that there r four buttons . one of them is onSelect. Click that overe here u can add multiple actions. Add an action to set a variable. Now it will work only if ur selecting a single value.

To do that click on the Add button in Add Actions -> External-> Select Set Variable . in here in first text box put the name of the variable u created to store value. in next text box put a formula like "=If(GetSelectedCount(CITEM) = 1,GetFieldSelections(CITEM)) and set a variable. Now u can add action for clear as well for setting anothere field using the value stored in a variable or the othere method is to use a macro. to do the rest.

With Regards

Amar