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

    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