List Box Association

[ashishpalkar]

Hi Expert

Please find attached QV document.

I have created 3 List Boxes

  Field

  Rank

  State

Field is combine list box of 'State' and 'Rank'.

What i am looking ,

When i Select/unselected any value from any of these list boxes , same action should apply on other list boxes.

e.g. If I select 'CA' from Field List box , State List box should highlight 'CA' , 

       If I unselected 'CA' from Field List Box, State List box should unselect 'CA' 

Thanks in advance.

[Gysbert_Wassenaar]

Why? When you select CA in either field then it will become the only possible value in the other field. If you deselect it in one field it will become a possible value again in the other field. Why does the 'selected' green color matter?

[ashishpalkar]

Hi Gysbert

Thanks for reply, other than selected green color the main focus is on

If I unselected 'CA' from Field List Box, State List box should unselect 'CA' as well. 

[Gysbert_Wassenaar]

Why? There's no functional difference?

[ashishpalkar]

There is difference, select 'CA' from field list box and use this expression and check the output

=if(GetSelectedCount(Field)=0,0,SubStringCount(Concat(Field, '|'), 'CA'))

this will return 1

=if(GetSelectedCount(State)=0,0,SubStringCount(Concat(State, '|'), 'CA'))

this will return 0

so there is no association

[Gysbert_Wassenaar]

So, use GetPossibleCount instead.

[ashishpalkar]

GetPossibleCount will only give you number of values selected , not which values selected.

[Gysbert_Wassenaar]

GetSelectedCount won't give you the selected values either

[ashishpalkar]

Is it possible to send sample QVW of your suggestion?

[Gysbert_Wassenaar]

Sure, you already posted it.