topic Set multiple default values for a list box in QlikView

Set multiple default values for a list box

Tue, 28 Jun 2011 19:46:11 GMT

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.

Set multiple default values for a list box

Tue, 28 Jun 2011 23:30:36 GMT

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

Re: Set multiple default values for a list box

erichshiino — Wed, 29 Jun 2011 01:38:55 GMT

Hi,

Your seach string should be:

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

You can also check the attachment.

Set multiple default values for a list box

Wed, 29 Jun 2011 16:31:11 GMT

Thanks Guys! The issue is now solved.

Set multiple default values for a list box

Anonymous — Wed, 02 May 2012 13:55:22 GMT

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 .