Set multiple default values for a list box

Tue, 03 Apr 2012 10:54:52 GMT

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

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.

Tue, 03 Apr 2012 16:02:20 GMT

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:

Thanks a lot

topic Set multiple default values for a list box in QlikView