topic Averages in QlikView https://community.qlik.com/t5/QlikView/Averages/m-p/197940#M503395 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Quick question: I'm able to average simple variables, however, the avg. function doesn't seem to work when I'm using set analysis. In my business, we have several types of sales, all housed under the variable 'sales' and differentiated by another variable called 'transaction type'. I've been using set analysis to differentiate amongst the different types of sales and it works well. However, I'm unable to calculate averages, standard deviations, etc and I'm pretty sure it has to do with the set analysis.</P><P>Has anyone else found this problem? If so, is there a way around it? I've attached an example to help explain my issue better.</P><P>Thanks for the help!</P><P></P><P>Matt</P></BODY></HTML> Tue, 22 Jun 2010 19:31:35 GMT 2010-06-22T19:31:35Z Averages https://community.qlik.com/t5/QlikView/Averages/m-p/197940#M503395 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Quick question: I'm able to average simple variables, however, the avg. function doesn't seem to work when I'm using set analysis. In my business, we have several types of sales, all housed under the variable 'sales' and differentiated by another variable called 'transaction type'. I've been using set analysis to differentiate amongst the different types of sales and it works well. However, I'm unable to calculate averages, standard deviations, etc and I'm pretty sure it has to do with the set analysis.</P><P>Has anyone else found this problem? If so, is there a way around it? I've attached an example to help explain my issue better.</P><P>Thanks for the help!</P><P></P><P>Matt</P></BODY></HTML> Tue, 22 Jun 2010 19:31:35 GMT https://community.qlik.com/t5/QlikView/Averages/m-p/197940#M503395 2010-06-22T19:31:35Z Averages https://community.qlik.com/t5/QlikView/Averages/m-p/197941#M503396 <HTML><HEAD></HEAD><BODY><P>Try this</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">avg({&lt;[Transaction Type ID]={"10"}&gt;} [Sales])</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Tue, 22 Jun 2010 19:56:39 GMT https://community.qlik.com/t5/QlikView/Averages/m-p/197941#M503396 2010-06-22T19:56:39Z Averages https://community.qlik.com/t5/QlikView/Averages/m-p/197942#M503398 <HTML><HEAD></HEAD><BODY><P>Works perfectly - Thanks Nick!</P></BODY></HTML> Tue, 22 Jun 2010 20:16:21 GMT https://community.qlik.com/t5/QlikView/Averages/m-p/197942#M503398 2010-06-22T20:16:21Z