Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the meaning of below code?
=only({1}[Monthname])
Please advise.
Thanks in advance.
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.
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.
it will take only monthname i.e as it is in field
and{1} -> ignores all selections
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;
Hi,
maybe this helps:
http://community.qlik.com/blogs/qlikviewdesignblog/2012/08/03/the-only-function
regards
Marco
Hey,
Check these..
Only() function in qlikview - what is the use?
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
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.
Thank you All.