topic Re: Only function in Qlikview in QlikView

Only function in Qlikview

Sat, 22 Nov 2014 15:12:42 GMT

What is the meaning of below code?
=only({1}[Monthname])

Please advise.

Thanks in advance.

Re: Only function in Qlikview

Anonymous — Sat, 22 Nov 2014 15:25:51 GMT

The {1} in it means to to ignore all selections.

And the only will return the value of Monthname only of if it only has a single value in all it rows, otherwise it will return null.

Re: Only function in Qlikview

SunilChauhan — Sat, 22 Nov 2014 15:28:47 GMT

it will take only monthname i.e as it is in field

and{1} -> ignores all selections

only(expression )

If expression over a number of records, as defined by a group by clause, contains only one numeric value, that value is returned. Else, NULL is returned.

Example:

Load Month, only(Price) as OnlyPriceSoldFor from abc.csv group by Month;

Re: Only function in Qlikview

MarcoWedel — Sun, 23 Nov 2014 00:03:14 GMT

Hi,

maybe this helps:

http://community.qlik.com/blogs/qlikviewdesignblog/2012/08/03/the-only-function

regards

Marco

Re: Only function in Qlikview

Anonymous — Sun, 23 Nov 2014 00:35:32 GMT

Hey,

Check these..

Only() function in qlikview - what is the use?

Use of ONLY Function

Apart from above..Only function can be also used for serving purpose showed in below thread.

Re: Update textbox with selected value description

Regards,

Chinna

Re: Only function in Qlikview

jagan — Sun, 23 Nov 2014 03:28:16 GMT

Hi Arjun,

=only({1}[Monthname])

{1} will ignore all the fields selections

Only() - will return the possible value of a given dimension, this will return if you have multiple possible values, so you should you this with bit more care, if you have multiple values then you can use

=Concat(DimnensionName, ',')

Or if you any one possible value you can Min(), Max() for numbers and MinString() and MaxString() for string dimensions.

Hope this helps you.

Regards,

Jagan.

Re: Only function in Qlikview

Sun, 23 Nov 2014 14:12:41 GMT

Thank you All.