topic Re: List box default value selection in QlikView

List box default value selection

Fri, 20 Jun 2014 10:56:26 GMT

Team

i am having the following values in the list box

current forcast

current open orders

current plan

current sales

prior year forecast

prior year plan

prior year sales

However i need to select the following values as default

current forecast

current open orders

current plan

current sales

i tried with the set field at the open document like the following syntax

= '(' & 'Current Forecast' & ',' & 'Current Plan' & ',' & 'Current Sales' & ')'

= '(' & 'Current Forecast' & 'I' & 'Current Plan' & '|' & 'Current Plan' & ')'

I would like to set these values as default with our vbscript or java script... can any one help me out on this.

Re: List box default value selection

tresB — Fri, 20 Jun 2014 10:58:59 GMT

Instead of macro use trigger . Set triggger on 'OnOpen' event of document.

Re: List box default value selection

Fri, 20 Jun 2014 11:33:54 GMT

This syntax is not working.

Re: List box default value selection

tresB — Fri, 20 Jun 2014 11:38:16 GMT

Srinivasan R wrote:

This syntax is not working.

Your second expression in the search string should work.

Re: List box default value selection

Fri, 20 Jun 2014 12:14:55 GMT

- create variable either in script or on front end to store a vale yes or no

if(match([Your field name],'[current forecast]','[current open orders]','[current plan]','[current sales]'),Yes,No) as VariableYesNo

- set a trigger to select the default value yes which set the values that you are after in the list box

Thanks and regards

Padma

Re: List box default value selection

Anonymous — Fri, 20 Jun 2014 12:50:19 GMT

Hi,

Go to Document Properties - In Triggers Tab:

Under document Event Triggers :Select 'On open' Option and Click on Add Action button

In the Add window Click on Add and 'Select in Field' option

Enter the Field name and values to be selected by default when the document is opened.

For ex :

Fieldname:field1

Value : ='A'

Fieldname:field1

Value : ='B'

Note:only one value can be set at a time.If u want to values to be selected, then u should add 'Select in field' option twice.

Re: List box default value selection

Fri, 20 Jun 2014 13:03:39 GMT

not working, last only will set and more over we have space

Re: List box default value selection

Fri, 20 Jun 2014 13:03:57 GMT

not working

Re: List box default value selection

Fri, 20 Jun 2014 13:08:09 GMT

both are not working because of space,,,,

Re: List box default value selection

MayilVahanan — Fri, 20 Jun 2014 13:10:04 GMT

Can you post a sample file?

Re: List box default value selection

Anonymous — Fri, 20 Jun 2014 13:23:23 GMT

Try with this , It is working fine

Fieldname: field1

Value : ='(A|B|C)'

Re: List box default value selection

Anonymous — Fri, 20 Jun 2014 13:58:27 GMT

double quotes are needed for strings with spaces (QV v10+) ...try this:

= '("Current Forecast" | "Current Plan" | "Current Sales")'

Re: List box default value selection

Anonymous — Fri, 20 Jun 2014 14:06:12 GMT

Double quotes are required only if the string is of two word, else if it is a single word then it is not necessary.

For Ex

Fieldname: field1

Value : ='(France|"United States"|Chile)'

Re: List box default value selection

Anonymous — Fri, 20 Jun 2014 14:51:37 GMT

that is exactly what i said - double quotes are needed for "strings with spaces". this only works on QV v10+...and doesn't work on previous versions of QV.