Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gerrycastellino
Creator III
Creator III

Expression help

I have the foll. data set:


CategoryProductPartSales
acaa1100
acaa1100
acaa2100
acbb1100
acbb2100
accc1100
accc2100


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

5 Replies
ecolomer
Master II
Master II

See example

IAMDV
Luminary Alumni
Luminary Alumni

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,

DV

www.QlikShare.com

gerrycastellino
Creator III
Creator III
Author

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 !

IAMDV
Luminary Alumni
Luminary Alumni

I'm glad you got it.

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

Cheers,

DV