Create a listbox with several variables

[pauldamen]

Dear all,

I want to create a listbox containing different variables I made which you can select.

So I have 5 variables created (5 formulas) which I  want to put in a listbox so that users can select 1 which is then put into a graph.

How can I put the 5 variables in 1 listbox? I can't make a group because it is nog cyclic or drill down, I want to display the five variables just in a row.

How someone can help me!

Kind regards,

Paul

[shree909]

Hi I am not sure but try like this.. goto the  properties of listbox

when u create list box for one field ,when u scroll down the fieldnames u will find a option expression for listbox,

then use the necesssary formulas  and create ur own list box..

[whiteline]

Hi.

Use inline sstatement in script to load your 5 formulas into one field. Then you could use this field in a listbox.

[pauldamen]

How can I make 5 formulas loaded into 1 field using an inline statement?

[#5]

load * inline [

     fieldname

     value1

     value2

     value3

     value4

     value5

];

and then use fieldname for your listbox

regards,

MT

[pauldamen]

Hi,

Is not working, it doesn't take the formula, the formula format looks like this:

sum([Betrokken bij echtscheiding <18])/sum([Jongeren onder 18 jaar])*1000;

But after the second bracket (before the next sum) it stops the formula, if have tried to put " around it but that doesn't help either.

Any ideas?

Regards,

Paul

[whiteline]

Two things: the quotes  + dollar-sign expansion

[pauldamen]

Also with the quotes and the $ sign it doesn't work

[#9]

Have you tried single quotes?

[#10]

if you want to see the result have you tried to put a = at the beginning?