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: 
MuraliPrasath
Creator III
Creator III

SetAnalysis Question.

Hi,

I want to sum "Licenses" based on distinct "Users".

Need help!

1 Solution

Accepted Solutions
sunny_talwar

May be this:

Sum(Aggr(Only(Licenses), Users))

or

Count(Aggr(Only(Licenses), Users))

Update: Not sure if you would Sum or Count? I think it should be Count, but don't really know your data. Also not sure how your data is but if you have user as dimension you can try this

Count(DISTINCT Licenses)

View solution in original post

4 Replies
sunny_talwar

May be this:

Sum(Aggr(Only(Licenses), Users))

or

Count(Aggr(Only(Licenses), Users))

Update: Not sure if you would Sum or Count? I think it should be Count, but don't really know your data. Also not sure how your data is but if you have user as dimension you can try this

Count(DISTINCT Licenses)

MK_QSL
MVP
MVP

SUM(Aggr(COUNT(Licenses),Users))

or

SUM(Aggr(SUM(Licenses),Users))

swuehl
MVP
MVP

Could you please be a bit more descriptive?

QlikCommunity Tip: How to get answers to your post?

Chanty4u
MVP
MVP

May be

SUM(Aggr(COUNT(Licenses),Users))

or

SUM(Aggr(Distinct COUNT(Licenses),Users))