topic Re: How to Get Single Value Selection List Box Value in Set Expression and Variable ? in QlikView

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

Thu, 03 Dec 2015 23:28:56 GMT

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 — Thu, 03 Dec 2015 23:39:34 GMT

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 — Fri, 04 Dec 2015 01:50:45 GMT

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 — Fri, 04 Dec 2015 02:10:48 GMT

Hi,

To get value from listbox use

=Only(FieldName)

In expression

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

Hope this helps you.

Regards,

jagan.

rwunderlich — Fri, 04 Dec 2015 04:55:20 GMT

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

=Fieldname

Rob

Fri, 04 Dec 2015 20:09:39 GMT

Thanks for your help.