1 Reply Latest reply: Apr 3, 2012 12:02 PM by Giampiero Cina RSS

    Set multiple default values for a list box

    Giampiero Cina

      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.