Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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