topic Re: Matching data from 2 tables in an expression in QlikView https://community.qlik.com/t5/QlikView/Matching-data-from-2-tables-in-an-expression/m-p/394110#M1167949 <HTML><HEAD></HEAD><BODY><P>No, it just randomly works with some figures and not others even if they are identical.</P></BODY></HTML> Tue, 11 Sep 2012 10:39:16 GMT 2012-09-11T10:39:16Z Matching data from 2 tables in an expression https://community.qlik.com/t5/QlikView/Matching-data-from-2-tables-in-an-expression/m-p/394108#M1167947 <HTML><HEAD></HEAD><BODY><P>Good morning, I am trying to write an expression that colours a field in a table if 2 sets of data match :-</P><P></P><P>=if(sum(Cleared_Paid)&gt;=sum(Amt_Latest_Default_Notice),RGB(0,0,255),RGB(190,0,0))</P><P></P><P>This expression works for the most part but doesnt always work for reasons unknown. </P><P></P><P>Can anyone help with a better idea?</P><P></P><P>Paul.</P></BODY></HTML> Tue, 11 Sep 2012 08:08:17 GMT https://community.qlik.com/t5/QlikView/Matching-data-from-2-tables-in-an-expression/m-p/394108#M1167947 2012-09-11T08:08:17Z Re: Matching data from 2 tables in an expression https://community.qlik.com/t5/QlikView/Matching-data-from-2-tables-in-an-expression/m-p/394109#M1167948 <HTML><HEAD></HEAD><BODY><P>you mean doesnt work with the field with null value?</P></BODY></HTML> Tue, 11 Sep 2012 10:37:57 GMT https://community.qlik.com/t5/QlikView/Matching-data-from-2-tables-in-an-expression/m-p/394109#M1167948 2012-09-11T10:37:57Z Re: Matching data from 2 tables in an expression https://community.qlik.com/t5/QlikView/Matching-data-from-2-tables-in-an-expression/m-p/394110#M1167949 <HTML><HEAD></HEAD><BODY><P>No, it just randomly works with some figures and not others even if they are identical.</P></BODY></HTML> Tue, 11 Sep 2012 10:39:16 GMT https://community.qlik.com/t5/QlikView/Matching-data-from-2-tables-in-an-expression/m-p/394110#M1167949 2012-09-11T10:39:16Z Re: Matching data from 2 tables in an expression https://community.qlik.com/t5/QlikView/Matching-data-from-2-tables-in-an-expression/m-p/394111#M1167950 <HTML><HEAD></HEAD><BODY><P>you need to post sample file</P></BODY></HTML> Tue, 11 Sep 2012 10:42:17 GMT https://community.qlik.com/t5/QlikView/Matching-data-from-2-tables-in-an-expression/m-p/394111#M1167950 2012-09-11T10:42:17Z Re: Matching data from 2 tables in an expression https://community.qlik.com/t5/QlikView/Matching-data-from-2-tables-in-an-expression/m-p/394112#M1167951 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Are both fields associated in the same way with the dimensions in your chart? Have you tested the two sum expressions in the chart?</P><P></P><P>If you post a sample and/or screen shot, it would help to diagnose the problem.</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Tue, 11 Sep 2012 10:43:53 GMT https://community.qlik.com/t5/QlikView/Matching-data-from-2-tables-in-an-expression/m-p/394112#M1167951 jonathandienst 2012-09-11T10:43:53Z