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

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

Tue, 12 Aug 2014 06:17:54 GMT

I am confused with only() function in qlikview while using in chart expression.

table i m using

ex:

LOAD * INLINE [

sno, no

1, 20

2, 578

3, 344

4, 54

5, 34

6, 34

7, 34

8, 34

];

and in dimension i put the column sno and in expression i use "no"

and also try with only(no1).

chart is showing the same result.

what is the correct scenario to understand "only()" function in qlikview.

ans what is the use of only() function in qlikview

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

amit_saini — Tue, 12 Aug 2014 06:22:37 GMT

Gurjeet,

Please follow attachment.

Thanks,

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

ashfaq_haseeb — Tue, 12 Aug 2014 06:23:48 GMT

HI,

with Only() you can add aggregation.

Basically its an aggregate function.

Edit:

from QlikView help

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;

Regards

ASHFAQ

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

evan_kurowski — Tue, 12 Aug 2014 06:25:25 GMT

It is an aggregation function like Sum()

If all the rows in the aggregation sample have the identical value, Only() will return that value, otherwise it returns null.

In your chart each [sno] dimension evaluates to a single value for the field [no], once you add a row to your dataset upon which there are multiple possible [no] values for a single [sno], that evaluation of Only(no) will return null.

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

tresB — Tue, 12 Aug 2014 06:27:45 GMT

This discussion should be helpful: Re: Use of ONLY Function

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

Tue, 12 Aug 2014 06:55:43 GMT

thanks guys

all comments & links of urs are very helpful