Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SET ANALYSIS QUESTION

How Do I do tihs in SET Analysis

If(NET_INDEMNITY_PAID>1000000,1000000)

4 Replies
MK_QSL
MVP
MVP

There is no aggregation of sum or count or avg ?

Not applicable
Author

sum( If(NET_INDEMNITY_PAID>1000000,1000000,NET_INDEMNITY_PAID))

hic
Former Employee
Former Employee

IF you just want to sum the NET_INDEMNITIES that are greater than 1M, then you should do

     Sum( {$<NET_INDEMNITY_PAID={">1000000"}>} NET_INDEMNITY_PAID)

If you want to do something else, I do not think Set Analysis is the right tool.

HIC

timsaddler
Creator III
Creator III

You could set a "flag" in the data based on Indemnities Less than or Greater than 1000000.

Then use ths in the set analysis