topic Please explain this expression in QlikView

Please explain this expression

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Please explain this expression

Peter_Cammaert — Tue, 14 Mar 2017 14:35:28 GMT

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?

Re: Please explain this expression

shekhar_analyti — Tue, 14 Mar 2017 14:39:28 GMT

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 .

Re: Please explain this expression

swuehl — Tue, 14 Mar 2017 15:12:40 GMT

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

Re: Please explain this expression

shekhar_analyti — Wed, 15 Mar 2017 08:23:40 GMT

I am attaching sample qvw .

Please explain only() in that context .

Re: Please explain this expression

beck_bakytbek — Wed, 15 Mar 2017 08:45:58 GMT

Hi Shekhar,

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

i hope that helps

beck

Re: Please explain this expression

swuehl — Wed, 15 Mar 2017 08:49:36 GMT

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?

Re: Please explain this expression

shekhar_analyti — Wed, 15 Mar 2017 09:10:44 GMT

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

Thank You Stefan ..