topic Re: List Box Association in QlikView

List Box Association

ashishpalkar — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: List Box Association

Gysbert_Wassenaar — Thu, 10 Mar 2016 18:21:37 GMT

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?

Re: List Box Association

ashishpalkar — Thu, 10 Mar 2016 18:25:11 GMT

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.

Re: List Box Association

Gysbert_Wassenaar — Thu, 10 Mar 2016 18:30:55 GMT

Why? There's no functional difference?

Re: List Box Association

ashishpalkar — Thu, 10 Mar 2016 18:42:31 GMT

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

Re: List Box Association

Gysbert_Wassenaar — Thu, 10 Mar 2016 18:45:56 GMT

So, use GetPossibleCount instead.

Re: List Box Association

ashishpalkar — Thu, 10 Mar 2016 18:49:14 GMT

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

Re: List Box Association

Gysbert_Wassenaar — Thu, 10 Mar 2016 18:55:01 GMT

GetSelectedCount won't give you the selected values either

Re: List Box Association

ashishpalkar — Thu, 10 Mar 2016 19:00:43 GMT

Is it possible to send sample QVW of your suggestion?

Re: List Box Association

Gysbert_Wassenaar — Thu, 10 Mar 2016 19:01:57 GMT

Sure, you already posted it.

Re: List Box Association

ashishpalkar — Thu, 10 Mar 2016 19:47:17 GMT

This is not solution what I am looking though..

Re: List Box Association

Gysbert_Wassenaar — Fri, 11 Mar 2016 06:28:26 GMT

I don't understand why you want that 'solution' in the first place. What problem is it supposed to solve?

Re: List Box Association

Fri, 11 Mar 2016 13:46:18 GMT

Hi,

Please have a look at below thread where the attached QVW is working as per your requirement.

https://community.qlik.com/thread/83581

Select Value in a list box based on Selection from another one

Thanks,

Itishree

Re: List Box Association

ashishpalkar — Fri, 11 Mar 2016 18:36:29 GMT

Thanks Itishree, this is perfect solution what I am looking for...

Re: List Box Association

Saravanan_Desingh — Fri, 11 Mar 2016 19:05:41 GMT

I am not sure if this is relevant. But a good trick from Rob and worth reading.

Scoping Selections with Aggr() | Qlikview Cookbook

Re: List Box Association

ashishpalkar — Fri, 11 Mar 2016 19:12:52 GMT

Thanks Saran, this is also very useful...