Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

SET ANALYSIS QUESTION

How Do I do tihs in SET Analysis

If(NET_INDEMNITY_PAID>1000000,1000000)

4 Replies
MVP
MVP

Re: SET ANALYSIS QUESTION

There is no aggregation of sum or count or avg ?

Not applicable

Re: SET ANALYSIS QUESTION

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

Re: SET ANALYSIS QUESTION

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
Contributor III

Re: SET ANALYSIS QUESTION

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

Then use ths in the set analysis