topic Re: what is exact diffence between only() and aggr() in QlikView

what is exact diffence between only() and aggr()

deepakqlikview_123 — Mon, 09 Jun 2014 11:46:53 GMT

Hello Experts,

Can you please tell me what is exact difference between only() and aggr().

Thanks

Re: what is exact diffence between only() and aggr()

alexandros17 — Mon, 09 Jun 2014 11:50:32 GMT

ONLY:

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.

AGGR:

Returns a set of values of expression calculated over dimensions.

Re: what is exact diffence between only() and aggr()

amit_saini — Mon, 09 Jun 2014 11:51:25 GMT

Deepak,

Check this:

Use of ONLY Function

Thanks,
AS

Re: what is exact diffence between only() and aggr()

lironbaram — Mon, 09 Jun 2014 11:52:34 GMT

only returns a value only if there is one distinct value in the filed we check

example :

only(EmployeeName) will return a value only if in the field EmployeeName will have 1 value

aggr returns a set of result according to the dimensions we defined in the function

aggr(if(sum(sales)>100,EmplyoeeName),EmployeeName)

will return a list of all emplyoees where thier sales are more than 100

Re: what is exact diffence between only() and aggr()

swuehl — Mon, 09 Jun 2014 11:58:03 GMT

Well, I don't think the two functions have much in common, so maybe it's easier if you tell what you think they share?

Re: what is exact diffence between only() and aggr()

hic — Mon, 09 Jun 2014 11:58:06 GMT

Only() is an aggregation function.

Aggr() is not an aggregation function.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/05/19/function-classes

HIC