Hiding list box value

[Anonymous]

Hi all two list boxes in one contains year values 2013,20140,2015 and other list box contains month values jan,feb,....dec.

Now my requirement is when i click on 2015 month list box should only jan feb and march

Thanks

[malini_qlikview]

Hi,

Go to the list box properties and select Hide excluded

[simsondevadoss]

in month filter give it as ,

=Aggr(Only( {<  month= p(month) >}month),month)

[Anonymous]

hi

i tried but i need other than hide exclude option.

[pokassov]

Hi!

I've tested Simson's approach and found it well except one particular thing.

There is a calendar table in my model with dates till 2015-12-31.

If I select 2015, I will see all of the 12 months.

I've just a little bit changed Simon's expression.

=Aggr(Only( {<month= p({$<date={'<=$(=date(today()))'}>}month) >}month),month)

[sujeetsingh]

Why want to just show those months do they have some conditional association with the years.

[Anonymous]

Yes !! sujeeth ,

it has to show only jan feb and march in 2015.

[Anonymous]

Hi ,

Is it possible for current problem

if(getcurrentselection(Year=2015),'jan','feb','mar')