How to Get Single Value Selection List Box Value in Set Expression and Variable ?

[#1]

Hi Friends,

I have on list box which is single value selection only.

once user will select one value from this list box,

i would need to pass this value to set expression and

also assign this value to variable ?

How we can do this in QV ?

[swuehl]

Variable definition:

=Only(FieldName)

Set expression (though it's unclear how your set expression looks like and where you want to use the variable), just as example:

=Sum({<Month = {"<=$(=Only(FieldName))"} >} Sales)

[sunny_talwar]

I think it would be better if you give more details (may be a sample) so that we can help you with a better helpful answer.

[jagan]

Hi,

To get value from listbox use

=Only(FieldName)

In expression

=Sum({<FieldName= {"$(=Only(FieldName))"} >} MeasureName)

Hope this helps you.

Regards,

jagan.

[rwunderlich]

‌BTW, only() is the default function. So you can simplify your expression as

=Fieldname

Rob

[#6]

Thanks for your help.