Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
MuraliPrasath
Contributor II

SetAnalysis Question.

Hi,

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

Need help!

1 Solution

Accepted Solutions

Re: SetAnalysis Question.

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)

4 Replies

Re: SetAnalysis Question.

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)

MVP
MVP

Re: SetAnalysis Question.

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

or

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

MVP
MVP

Re: SetAnalysis Question.

Could you please be a bit more descriptive?

QlikCommunity Tip: How to get answers to your post?

Chanty4u
Esteemed Contributor III

Re: SetAnalysis Question.

May be

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

or

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

Community Browser