topic Re: Exclusion From ListBox in QlikView

Exclusion From ListBox

vanderson009 — Wed, 11 Dec 2013 09:17:53 GMT

Hi folk,

I have Year field on my Dashbord,

I have taken Year field twice time, Suppose i click on one Year listsbox then,

I want second ListBox showing irrelivant Data.

For example... Year :- 2007,2008,2009,2010,2011,2012,2013

If i select 2007 On ListBox1 then Second ListBox Shown 2008,2009,2010,2011,2012,2013

Regards,

Villyee

MayilVahanan — Wed, 11 Dec 2013 09:32:33 GMT

Are you looking for this?

vanderson009 — Wed, 11 Dec 2013 09:50:52 GMT

Hi Mayil,

Yes U right......

But How u did it??

Regards,

Villeyy

MayilVahanan — Wed, 11 Dec 2013 10:09:51 GMT

Check in this

Setting -> Document properties -> Trigger -> Field Event Triggers -> OnSelect

Wed, 11 Dec 2013 10:15:09 GMT

Hi,

Try below:

For the second list box, use the below expression:

=Aggr(Only({<Year= e({<Year= {$(=GetFieldSelections(Year,',',20))}>})>} Year), Year)