Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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 ?

5 Replies
swuehl
MVP
MVP

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
Partner - Champion III
Partner - Champion III

Hi,

To get value from listbox use

=Only(FieldName)

In expression

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


Hope this helps you.


Regards,

jagan.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

=Fieldname

Rob

Not applicable
Author

Thanks for your help.