Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
pjpkumar26
Contributor III
Contributor III

Qlik Sense Set Analysis

Hi All,

I got the below function and I need this value to not change when I select any filter in the Application

How can I achieve this by Set Analysis

sum(aggr((SME),[SupervisorID]))*.9

Thanks In Advance

Sudheer

Labels (5)
2 Replies
MatheusC
Specialist II
Specialist II

Hi, @pjpkumar26 

you can use it in the expression {1}, as an example below:
sum({1} sale)

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
agigliotti
Partner - Champion
Partner - Champion

Hi @pjpkumar26 ,

Maybe this:

sum( {1} aggr( {1} (SME),[SupervisorID] ) ) *.9

I hope it can helps.

Best Regards