topic Re: How to get only associated values in the list boxes by selecting a value in other list box? in QlikView

How to get only associated values in the list boxes by selecting a value in other list box?

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

Hi all,

I have three list boxes, Year, Month & Title.

I need to an expression where I need to get only associated values in Year & title, by selecting a value in Month.

Please help me out.

Thank You.

Re: How to get only associated values in the list boxes by selecting a value in other list box?

sunny_talwar — Fri, 17 Mar 2017 15:50:23 GMT

May be try this as your list box expressions

=Aggr(Only({1<Month = p(Month)>} Year), Year)

=Aggr(Only({1<Month = p(Month)>} title), title)

Re: How to get only associated values in the list boxes by selecting a value in other list box?

Peter_Cammaert — Fri, 17 Mar 2017 16:03:18 GMT

Every listbox has a property called "Hide excluded". Enabling this checkbox will hide all grey values from the current listbox.

Re: How to get only associated values in the list boxes by selecting a value in other list box?

Anonymous — Fri, 17 Mar 2017 16:21:04 GMT

use CTRL + T and post a screenshot of your data structure please...

Re: How to get only associated values in the list boxes by selecting a value in other list box?

sn_9052 — Fri, 17 Mar 2017 18:10:57 GMT

Hi,

I checked Hide Excluded Option, But still its showing the Empty Grey Color along with Associated values.

Regards,

Hasini

Re: How to get only associated values in the list boxes by selecting a value in other list box?

sn_9052 — Fri, 17 Mar 2017 18:13:47 GMT

Hi,

Please find the below snap, I implemented that function but still it showing Empty grey color along with associated value.

Re: How to get only associated values in the list boxes by selecting a value in other list box?

sn_9052 — Fri, 17 Mar 2017 18:16:38 GMT

Hi,

Please find the below data structure.

Re: How to get only associated values in the list boxes by selecting a value in other list box?

sunny_talwar — Fri, 17 Mar 2017 18:58:39 GMT

This needs to go on the general tab and not the expressions tab

Re: How to get only associated values in the list boxes by selecting a value in other list box?

sn_9052 — Fri, 17 Mar 2017 19:44:06 GMT

Hurreh.....

Thank You soo much Sunny.. Its Working now.

Thanks a lot.

Re: How to get only associated values in the list boxes by selecting a value in other list box?

sunny_talwar — Fri, 17 Mar 2017 19:45:46 GMT

Awesome

Re: How to get only associated values in the list boxes by selecting a value in other list box?

sn_9052 — Fri, 17 Mar 2017 19:50:53 GMT

Hi Sunny,

Could you please Explain about that formula.

=Aggr(Only({1<[Company Name] = p([Company Name])>} Product), Product)

Please help me.

Re: How to get only associated values in the list boxes by selecting a value in other list box?

MarcoWedel — Fri, 17 Mar 2017 23:20:59 GMT

Hi,

other listbox expressions derived from Sunny's solution that might also work for you:

=Aggr(Only({1<Month=$::Month>} Year),Year)

or just

=Aggr(Year,Year)

if you do not only care about month field selections

hope this helps

regards

Marco

Re: How to get only associated values in the list boxes by selecting a value in other list box?

sn_9052 — Sat, 18 Mar 2017 06:22:48 GMT

Hi Macro,

Thank You So much

The function which you have posted is also working ....

Thanks a lot.

Regards,

Hasini.

On Fri, Mar 17, 2017 at 4:21 PM, Marco Wedel <qcwebmaster@qlikview.com>

Re: How to get only associated values in the list boxes by selecting a value in other list box?

MarcoWedel — Sat, 18 Mar 2017 18:18:13 GMT

you're welcome

please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco