Please explain this expression

[shekhar_analyti]

Hi All ,

Please explain this expression :

Only({1}(Match(Country,'USA','UK','BR','IN','AG')))

What is the significance of only to this  expression  ?

Regards

Shekar

[Peter_Cammaert]

Only() converts an ordinary function call returning a single value into an aggregation expression (example for use in chart expressions where Only() is often implied.)

Highly context-dependent. Where is it used?

[shekhar_analyti]

Hi Peter

Thanks for reply .

It was used for custom sorting of a Multibox to ensure that on user selection position of field value does not change .. Now can you help me understand , how it works .

[swuehl]

I guess the main reason for usage is to allow the application of set analysis (which you can only use in combination with an aggregation function like Sum(), Count() .... or Only() ! )

The Only Function

[shekhar_analyti]

I am attaching sample qvw .

Please explain only()  in that context .

[beck_bakytbek]

Hi Shekhar,

look at this: https://community.qlik.com/docs/DOC-8146

i hope that helps

beck

[swuehl · Accepted solution]

The explicite use of the only function allows to add a set expression, which may help in ignoring user selections:

User selected Georgia. See the difference?

[shekhar_analyti]

I got it now ... Only() for Demystified to me ..

Thank You Stefan ..