Select in Field Action

[#1]

I want to have multiple selections in a list box when I open the Qlikview file.

Inside the OnOpen trigger, does anyone know the correct syntax of the search string of the action Select in Field?

[#2 · Accepted solution]

(selection1|selection2)

IN YOUR TERMS

(APPLE|ORANGE)

[#3]

Thanks.

I've another Question.

If the list box is sorted by Text A->Z, what's the search string like if I want to select the top 3 by default?

[#4]

HAS THE LIST BOX GOT AN EXPRESSION AS WELL OR JUST A LIST BOX WITHOUT EXPRESSIONS?

[#5]

It's a list box without expressions.

Actually, it's a list of years as attached and I want to select the recent three years by default.

[#6]

II WOULD -----------------------------

LEFT JOIN (MASTER ALENDER)

LOAD  ROWNO() AS CURRENTYEAR,

FISCALYEAR

ORDER BY FISCALYEAR DESC;

----------------------------

IN THE MASTER CALENDER THEN YOU WILL HAVE ROWNO VALUES AGAINST EACH YEAR. AND CAN DO SELECTION BASED ON CURRENTYEAR FIELD.