topic Re: SetAnalysis Question. in QlikView

SetAnalysis Question.

MuraliPrasath — Fri, 13 May 2016 09:21:19 GMT

Hi,

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

Need help!

Re: SetAnalysis Question.

sunny_talwar — Fri, 13 May 2016 09:22:40 GMT

May be this:

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

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)

Re: SetAnalysis Question.

MK_QSL — Fri, 13 May 2016 09:22:44 GMT

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

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

Re: SetAnalysis Question.

swuehl — Fri, 13 May 2016 09:22:51 GMT

Could you please be a bit more descriptive?

QlikCommunity Tip: How to get answers to your post?

Re: SetAnalysis Question.

Chanty4u — Fri, 13 May 2016 09:23:54 GMT

May be

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

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