topic Compare fields in set analysis in QlikView https://community.qlik.com/t5/QlikView/Compare-fields-in-set-analysis/m-p/224348#M76772 <HTML><HEAD></HEAD><BODY><P></P><P>Hello All,</P><P>I have 2 fields in my table : Project Completion Date and Project due date. Now I need sum of all rows for which the Project completion date &gt; project due date. I tried using the following set analysis but it didnt work.</P><P>=Sum({1&lt;[PPO Indicator] = {Close},[Project Status] = {Completed},[Project Completion Date]={"&gt;=$(=[Project Due Date])"} &gt;}[Value])</P><P>The user does not select any values in these fields.</P><P>Thanks</P><P>Arun</P><BR /><BR /></BODY></HTML> Mon, 26 Oct 2009 12:30:32 GMT 2009-10-26T12:30:32Z Compare fields in set analysis https://community.qlik.com/t5/QlikView/Compare-fields-in-set-analysis/m-p/224348#M76772 <HTML><HEAD></HEAD><BODY><P></P><P>Hello All,</P><P>I have 2 fields in my table : Project Completion Date and Project due date. Now I need sum of all rows for which the Project completion date &gt; project due date. I tried using the following set analysis but it didnt work.</P><P>=Sum({1&lt;[PPO Indicator] = {Close},[Project Status] = {Completed},[Project Completion Date]={"&gt;=$(=[Project Due Date])"} &gt;}[Value])</P><P>The user does not select any values in these fields.</P><P>Thanks</P><P>Arun</P><BR /><BR /></BODY></HTML> Mon, 26 Oct 2009 12:30:32 GMT https://community.qlik.com/t5/QlikView/Compare-fields-in-set-analysis/m-p/224348#M76772 2009-10-26T12:30:32Z