restrict listbox values in alternate states

[vipingarg23]

I have two listboxes A and B but Listbox B has alternate state and A don't have any alternate state. I want to limit the data in B based on A selections I am using below expression but it is not working, may be due to alternate states.

=if(Year(B)=A,B)

[mayankraoka]

Hi Vipin,

Try this suppose you have state1 for field B.

Try this in text box this wil affect.

= concat( distinct {State1<A= $::A>}B,  )

Regards,

Mayank

[tresesco]

Try like:

Aggr(Only({<B=$ :: A>}B),B)

If this doesn't work, please share a sample qvw.

[vipingarg23]

No..It is not working.

Please find the sample file as an attachment. here I want once I clicked on 2015, it should display only 201501.

[vipingarg23]

No. mayank. It is not working as well.

[mayankraoka]

Please check attached app.

Regards.

Mayank

[tresesco · Accepted solution]

Working expression:         =Aggr(Only({<A=$::A>} B),B)

[vipingarg23]

Great Tresesco and Mayank. It is working fine now. I appreciate your help. Thanks you so much.