Conditional selection

[QV_learner]

Hello Everyone!

I have a query regarding the conditional selection in QlikView.

Here is the scenario:

I have one multibox where I want to add condition.

When I select one value  for a field in multibox, it should select one specific value of another field in same box.

Example:

In below list box when I select Country as CA, the business family are listed as follows:

          

The requirement is that, when I select "CA" as country, the "O2" business family should automatically be selected excluding other values.

Could you please help me in putting conditions in order to achieve the results?

Thank You!

[neelamsaroha157]

You can add a trigger 'OnSelect' on the Country field then choose the 'Select in Field', put 'Business Family' in 'Field' and in the search string you can have a IF condition something like =If(County = 'CA', 'O2', if(Country = 'BA', 'R1'))

[neelamsaroha157]

[QV_learner]

Thank You Neelam. This is great!
I have one more query where I require to select two fields and based on their selection, need to select the value from the third field.  I tried giving condition in trigger too; but no luck.
Could you please advise?

Here is the scenario:

Whenever I select Country as "CA", dropdown for  Business Family appears:

In this dropdown of Business Family, when I select O2 then there appears dropdown for Item.

In the dropdown for Item, based on previous selections of Country as "CA" and Business Family as "O2",automatically "Club Buttermilk" should get selected. 

  

So, how to apply trigger for such situations?

[Arthur_Fong · Accepted solution]

Try this:

I created the trigger in Field A and Field B.

When A ='CIP' and B='3' is selected, D='3' will be selected as well.

Take a look at Settings > Document Properties > Triggers > Field > Field Event Triggers > A and B > Check the expression

Thanks and regards,

Arthur Fong

[Brett_Bleess]

Vivek, please be sure you give proper recognition to those posts that helped you get what you needed by using the Accept as Solution button on those posts to mark them and let others know those helped you resolve your situation.

Regards,
Brett