topic Need help with expression in QlikView https://community.qlik.com/t5/QlikView/Need-help-with-expression/m-p/375037#M492275 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to change the way the "GAP" gets calculated within the attached Straight Table. The different parts to the formula are...</P><P></P><P>Average Sales = Total Sales / # Stores with Sales</P><P></P><P>If the Sales value (by Barcode/Store) is less than the Average, then the GAP = Average Sales - Sales (by Barcode / Store)</P><P></P><P>The easy part is to add the Average Sales column, but how would I test the Sales value (by Barcode/Store) against the Average Sales value without the Store being included withing this table?</P><P></P><P></P><P><IMG __jive_id="19105" class="jive-image-thumbnail jive-image" height="212" onclick="" alt="Table.png" src="https://community.qlik.com/legacyfs/online/19105_Table.png" style="width: 630px; height: 212.5834797891037px;" width="630" /></P></BODY></HTML> Mon, 30 Jul 2012 22:30:46 GMT 2012-07-30T22:30:46Z Need help with expression https://community.qlik.com/t5/QlikView/Need-help-with-expression/m-p/375037#M492275 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to change the way the "GAP" gets calculated within the attached Straight Table. The different parts to the formula are...</P><P></P><P>Average Sales = Total Sales / # Stores with Sales</P><P></P><P>If the Sales value (by Barcode/Store) is less than the Average, then the GAP = Average Sales - Sales (by Barcode / Store)</P><P></P><P>The easy part is to add the Average Sales column, but how would I test the Sales value (by Barcode/Store) against the Average Sales value without the Store being included withing this table?</P><P></P><P></P><P><IMG __jive_id="19105" class="jive-image-thumbnail jive-image" height="212" onclick="" alt="Table.png" src="https://community.qlik.com/legacyfs/online/19105_Table.png" style="width: 630px; height: 212.5834797891037px;" width="630" /></P></BODY></HTML> Mon, 30 Jul 2012 22:30:46 GMT https://community.qlik.com/t5/QlikView/Need-help-with-expression/m-p/375037#M492275 2012-07-30T22:30:46Z