Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 (2)
1 Reply
NevoPotok
Contributor II
Contributor II
Author

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

 

Thanks