Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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?

Thanks in advance

Jason

1 Solution

Accepted Solutions
MVP
MVP

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

2 Replies
MVP
MVP

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

Not applicable

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

Community Browser