2 Replies Latest reply: Sep 2, 2011 10:56 AM by Jason Newman

# Set analysis - comparing value a and b

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 :

• count({\$<A = B>} C)

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?

Jason

• ###### Re: Set analysis - comparing value a and b

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

• ###### Set analysis - comparing value a and b

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