Set multiple default values for a list box

[#1]

Hi,

I'm working on a qlikview app in version 9. The requirement is , when user opens the app it should year list box shoul default to current year , prev year and prev year-1.  To achive this I'm Settings -> Document Properties -> Triggers -> On Open -> Add actions

Here, I'm setting  values for the same list box thrice. Each time with different year.

When I open the doc, List box defaults to last value (of in the order setting).

I tried concatenating in one statement with comma seperated values as below. It did not work.

= '2011, 2010, 2009'

Please advice.

[#2]

Hi Krishnamurthy_Kr

It's happening because ur 2nd action is overriding 1st and 3rd action is overriding 2nd , that's the reason why only ur year 2009 is selecting ...

Thanks

Meher

[erichshiino · Accepted solution]

Hi,

Your seach string should be:

='>=$(=Year(today())-2)<=$(=Year(today()))'

You can also check the attachment.

[#4]

Thanks Guys! The issue is now solved.

[Anonymous]

Hi,

I have Requirement where i have to select

those customer Whose name Start with 'S'

on selection of a Button 'S'

can u help it out .