QlikView Scripting

[MuraliPrasath]

Hi,

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

Need help!

[sunny_talwar · Accepted solution]

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]

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

or

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

[swuehl]

Could you please be a bit more descriptive?

QlikCommunity Tip: How to get answers to your post?

[Chanty4u]

May be

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

or

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