Only function in Qlikview

[#1]

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

Please advise.

Thanks in advance.

[Anonymous]

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.

[SunilChauhan]

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;

[MarcoWedel]

Hi,

maybe this helps:

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

regards

Marco

[Anonymous]

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

[jagan · Accepted solution]

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.

[#7]

Thank you All.