topic summing if then columns in QlikView https://community.qlik.com/t5/QlikView/summing-if-then-columns/m-p/326750#M1178465 <HTML><HEAD></HEAD><BODY><P>I have several columns that are if columns based on a previous column.&nbsp; I would like to sum all the if columns(they are bonus columns) for a total bonus.&nbsp; It will only sum the columns if they meet all the criteria.&nbsp; Someone has to have every criteria of a bonus to pull a bonus.&nbsp; I want to pull the total even if column 2 or column 4 doesn't have a total but column 6 has one - i want to pull the result from column 6.&nbsp; </P><P></P><P>How can i do this.&nbsp; I have attached my screenshot </P><P></P><P><IMG alt="screenshot of qlikview.jpg" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/11755_screenshot+of+qlikview.jpg" width="450" /></P></BODY></HTML> Wed, 29 Feb 2012 00:15:55 GMT 2012-02-29T00:15:55Z summing if then columns https://community.qlik.com/t5/QlikView/summing-if-then-columns/m-p/326750#M1178465 <HTML><HEAD></HEAD><BODY><P>I have several columns that are if columns based on a previous column.&nbsp; I would like to sum all the if columns(they are bonus columns) for a total bonus.&nbsp; It will only sum the columns if they meet all the criteria.&nbsp; Someone has to have every criteria of a bonus to pull a bonus.&nbsp; I want to pull the total even if column 2 or column 4 doesn't have a total but column 6 has one - i want to pull the result from column 6.&nbsp; </P><P></P><P>How can i do this.&nbsp; I have attached my screenshot </P><P></P><P><IMG alt="screenshot of qlikview.jpg" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/11755_screenshot+of+qlikview.jpg" width="450" /></P></BODY></HTML> Wed, 29 Feb 2012 00:15:55 GMT https://community.qlik.com/t5/QlikView/summing-if-then-columns/m-p/326750#M1178465 2012-02-29T00:15:55Z