Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set multiple default values for a list box

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.

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

Hi,

Your seach string should be:

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

You can also check the attachment.

View solution in original post

4 Replies
Not applicable
Author

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
Partner - Master
Partner - Master

Hi,

Your seach string should be:

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

You can also check the attachment.

Not applicable
Author

Thanks Guys! The issue is now solved.

Anonymous
Not applicable
Author

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 .