topic Re: Conditional selection in QlikView

Conditional selection

QV_learner — Wed, 28 Aug 2019 14:31:08 GMT

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!

Re: Conditional selection

neelamsaroha157 — Wed, 28 Aug 2019 15:48:28 GMT

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'))

Re: Conditional selection

neelamsaroha157 — Wed, 28 Aug 2019 15:51:47 GMT

Re: Conditional selection

QV_learner — Thu, 29 Aug 2019 06:28:34 GMT

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?

Re: Conditional selection

Arthur_Fong — Thu, 29 Aug 2019 06:51:19 GMT

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

Re: Conditional selection

Brett_Bleess — Thu, 05 Sep 2019 19:11:39 GMT

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