topic Re: Select in Field Action in QlikView

Select in Field Action

Fri, 24 Oct 2014 03:03:12 GMT

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?

Fri, 24 Oct 2014 03:21:54 GMT

(selection1|selection2)

IN YOUR TERMS

(APPLE|ORANGE)

Fri, 24 Oct 2014 03:29:25 GMT

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?

Fri, 24 Oct 2014 03:36:39 GMT

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

Fri, 24 Oct 2014 03:40:21 GMT

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.

Fri, 24 Oct 2014 04:13:11 GMT

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.