topic Re: what is only() function how it works? in QlikView

what is only() function how it works?

Wed, 25 Nov 2020 16:16:04 GMT

what is only() function how it works?please give one example friends.

Chanty4u — Wed, 20 Apr 2016 06:21:17 GMT

chk dis

Anonymous — Wed, 20 Apr 2016 06:46:44 GMT

check this thread i think its helpful Use of ONLY Function

Wed, 20 Apr 2016 06:48:51 GMT

Lke You want to see the sales of selected year, selected-1 year and selected+1.

For example i selected 2006 , so i want to see sales for 2006,2005 and 2007.

In this scenario , we can use only() function-

here is the script :

Sum({<Year={$(=Only(Year))}>}Sales) - 2006

Sum({<Year={$(=Only(Year)-1)}>}Sales)-2005

Sum({<Year={$(=Only(Year)+1)}>}Sales)-2007

ajsjoshua — Wed, 20 Apr 2016 06:56:20 GMT

Hi,

It returns only one value or null incase multiple value returned.

ex:

country city

india Mumbai

India chennai

india delhi

only(country) means answer is india

only(city) means null.

Regards,

JOshua.

Chanty4u — Wed, 20 Apr 2016 07:00:06 GMT

hi,

did u chk dis?

When in dimension(column) all values are

the same ,Only will return this value:

(otherwise NULL)