topic Re: Hiding list box value in QlikView

Hiding list box value

Anonymous — Wed, 01 Apr 2015 09:21:30 GMT

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 — Wed, 01 Apr 2015 09:41:19 GMT

Hi,

Go to the list box properties and select Hide excluded

simsondevadoss — Wed, 01 Apr 2015 09:42:12 GMT

in month filter give it as ,

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

Anonymous — Thu, 02 Apr 2015 05:05:55 GMT

i tried but i need other than hide exclude option.

pokassov — Thu, 02 Apr 2015 06:14:04 GMT

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 — Thu, 02 Apr 2015 06:21:18 GMT

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

Anonymous — Sun, 05 Apr 2015 07:23:50 GMT

Yes !! sujeeth ,

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

Anonymous — Sun, 05 Apr 2015 07:25:14 GMT

Hi ,

Is it possible for current problem

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