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

[sn_9052]

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.

[sn_9052]

Hi Sunny,

Could you please Explain about that formula.

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

Please help me.

[MarcoWedel]

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

[sn_9052]

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>

[MarcoWedel]

you're welcome

please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco