topic Re: SET ANALYSIS QUESTION in QlikView

SET ANALYSIS QUESTION

Tue, 04 Feb 2014 15:06:19 GMT

How Do I do tihs in SET Analysis

If(NET_INDEMNITY_PAID>1000000,1000000)

MK_QSL — Tue, 04 Feb 2014 15:17:22 GMT

There is no aggregation of sum or count or avg ?

Tue, 04 Feb 2014 15:25:05 GMT

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

hic — Tue, 04 Feb 2014 15:45:11 GMT

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 — Tue, 04 Feb 2014 15:46:58 GMT

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

Then use ths in the set analysis