topic Set analysis - comparing value a and b in QlikView

Set analysis - comparing value a and b

Fri, 02 Sep 2011 14:20:56 GMT

Hi,

I want to create a chart with a count of the number of cases where:

Suggested Settlement = Actual Settlement

Suggested Settlement > Actual Settlement

Suggested Settlement < Actual Settlement

I started by looking at the count of cases where "Suggested Settlement = Actual Settlement"

Using SQL on the source database I know my answer is 21000

I have looked at other forum entries and the best advice seemed to be to use :

This did not work and ,the closest I can get within Qlikview is a count of 1500 using:

=count({$<[ACTUALSETTLEMENT] ={"=[SUGGESTEDSETTLEMENT]"}>} [ACTUALSETTLEMENT])

All other attempts have resulted in a zero return

I am obviously doing something wrong, can someone suggest a solution?

Thanks in advance

Jason

swuehl — Fri, 02 Sep 2011 14:42:29 GMT

Hi Jason,

I am not sure, but maybe you are looking for something like:

=count(if(A=B,C)) ??

i.e. compare for each record field values A and B, if equal count C.

Regards,

Stefan

Fri, 02 Sep 2011 14:56:36 GMT

Stefan,

The solution was so simple, but so effective. I think I got too obsessed with set analysis!

Thanks very much for your help.

Regards

Jason