topic Re: Expression help in QlikView

Expression help

gerrycastellino — Fri, 12 Sep 2014 22:26:38 GMT

I have the foll. data set:

Category	Product	Part	Sales
ac	a	a1	100
ac	a	a1	100
ac	a	a2	100
ac	b	b1	100
ac	b	b2	100
ac	c	c1	100
ac	c	c2	100

I'm stumbling on some results I'm getting with the foll expressions:

count(aggr(nodistinct sum(Sales),Category, Product, Part))

count(aggr(nodistinct sum(Sales),Category, Product))

count(aggr(nodistinct sum(Sales),Category))

Could somebody explain the above expressions, and what results I would get ?

Gerry

Re: Expression help

marcus_sommer — Sat, 13 Sep 2014 00:35:24 GMT

Have a look here:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/08/06/it-s-all-aggregations

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

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/11/when-should-the-aggr-function-not-be-used

- Marcus

Re: Expression help

ecolomer — Sat, 13 Sep 2014 03:45:46 GMT

See example

Re: Expression help

IAMDV — Sat, 13 Sep 2014 11:42:55 GMT

Gerry,

As mentioned by Marcus, please read the above posts to under the Aggr() function. In simple terms you are Grouping the data and aggregating (Sum in your case) by the fields mentioned above. Then you are counting the results and not eliminating any potential duplicate values.

Cheers,

www.QlikShare.com

Re: Expression help

gerrycastellino — Sun, 14 Sep 2014 01:58:07 GMT

Yes thanks all for you help ! it became clear to me after I posted.

The count is simply returning the count of the number of items in the aggr function.

i.e. count(100,200,300) returns 3.

Very elegant from QV !

Re: Expression help

IAMDV — Sun, 14 Sep 2014 06:54:32 GMT

I'm glad you got it.

Please can you close the thread by marking the relevant answer(s). It might help other users.

Cheers,