Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set multiple default values for a list box

Hi guys,

I'm in trouble with a multiple selection setting.

When users opens the qlikview doc it should appear a month list box with a default setting.

I created an in line table with my months (fron Jan to Dec).

Default setting has to be from January to current month-1.

For instance, now must be selected:

Jan

Feb

Mar

In this discussion

http://community.qlik.com/thread/30788

I found a good idea to solve my problem.

Unfortunately it's based on a list box with numerical values.

I have a string for values and the same solution doesn't work.

I tried this expression:

='>$(=left(monthname(Today(),-$(vMesiPrec)),3))<$(=left(monthname(Today(),-1),3))'

and  i have:

>Jan<Mar

As I've alredy written it doesn't work.

Any idea to help me?

Thank you so much in advance.

1 Solution

Accepted Solutions
Not applicable
Author

Hi guys,

thanks to another thread I have the solution.

if you use this basic :

= '("' & 'Gen' & '"|"' & 'Feb' & '"|"' & 'Mar' & '")'

for instance with an action, it works perfectly.

I have to thanks Rob Wunderlich and his solution in this thread:

http://community.qlik.com/thread/35287

Thanks a lot

View solution in original post

1 Reply
Not applicable
Author

Hi guys,

thanks to another thread I have the solution.

if you use this basic :

= '("' & 'Gen' & '"|"' & 'Feb' & '"|"' & 'Mar' & '")'

for instance with an action, it works perfectly.

I have to thanks Rob Wunderlich and his solution in this thread:

http://community.qlik.com/thread/35287

Thanks a lot