Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
NevoPotok
Contributor II
Contributor II

Set Analysis Question

Hi,

I have a model which display feature usage and I want to display only accounts that use specific feature more than X (variable) time.

Qlik Question.png

I tried to use this exp. but it didn't work:

sum( {$<AccountID = P({<"=Sum(Aggr(Sum(Usage),AccountID,FeatureID))={>$(X)"} >})>} Usage )

Explanation: return only the AccountID the sum of the usage by FeatureID is greater than X, and only for those AccountID to Sum the Usage.

 

Appreciate any assistance 

Labels (4)
1 Reply
NevoPotok
Contributor II
Contributor II
Author

@sunny_talwar  @swuehl  really appreciate if one of you can assist with this issue

 

Thanks