Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
erich_shiino
Honored Contributor

Re: Set multiple default values for a list box

Hi,

Your seach string should be:

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

You can also check the attachment.

4 Replies
Not applicable

Set multiple default values for a list box

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

erich_shiino
Honored Contributor

Re: Set multiple default values for a list box

Hi,

Your seach string should be:

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

You can also check the attachment.

Not applicable

Set multiple default values for a list box

Thanks Guys! The issue is now solved.

sach_sahu1
New Contributor III

Set multiple default values for a list box

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 .

Community Browser