topic Re: set analysis for avg caluclation in QlikView https://community.qlik.com/t5/QlikView/set-analysis-for-avg-caluclation/m-p/761983#M1039090 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Can you outline your Data in terms of Column/ rows as an example ?</P><P>That may help understand and provide you a soulution !</P><P></P><P>Cheers ! </P></BODY></HTML> Fri, 09 Jan 2015 10:37:57 GMT 2015-01-09T10:37:57Z set analysis for avg caluclation https://community.qlik.com/t5/QlikView/set-analysis-for-avg-caluclation/m-p/761982#M1039089 <HTML><HEAD></HEAD><BODY><P>iam using dimension date in chart and want to caluclate averge number of treatments for each counter</P><P>how can we write expression in set analysis</P></BODY></HTML> Fri, 09 Jan 2015 10:27:31 GMT https://community.qlik.com/t5/QlikView/set-analysis-for-avg-caluclation/m-p/761982#M1039089 2015-01-09T10:27:31Z Re: set analysis for avg caluclation https://community.qlik.com/t5/QlikView/set-analysis-for-avg-caluclation/m-p/761983#M1039090 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Can you outline your Data in terms of Column/ rows as an example ?</P><P>That may help understand and provide you a soulution !</P><P></P><P>Cheers ! </P></BODY></HTML> Fri, 09 Jan 2015 10:37:57 GMT https://community.qlik.com/t5/QlikView/set-analysis-for-avg-caluclation/m-p/761983#M1039090 2015-01-09T10:37:57Z Re: set analysis for avg caluclation https://community.qlik.com/t5/QlikView/set-analysis-for-avg-caluclation/m-p/761984#M1039091 <HTML><HEAD></HEAD><BODY><P>Can you upload an example?</P></BODY></HTML> Sat, 10 Jan 2015 19:35:35 GMT https://community.qlik.com/t5/QlikView/set-analysis-for-avg-caluclation/m-p/761984#M1039091 ecolomer 2015-01-10T19:35:35Z Re: set analysis for avg caluclation https://community.qlik.com/t5/QlikView/set-analysis-for-avg-caluclation/m-p/761985#M1039092 <HTML><HEAD></HEAD><BODY><P>dimension: date</P><P>expression: Avg(Aggr(count(treatments),counter))</P></BODY></HTML> Sun, 11 Jan 2015 00:41:42 GMT https://community.qlik.com/t5/QlikView/set-analysis-for-avg-caluclation/m-p/761985#M1039092 MarcoWedel 2015-01-11T00:41:42Z Re: set analysis for avg caluclation https://community.qlik.com/t5/QlikView/set-analysis-for-avg-caluclation/m-p/761986#M1039093 <HTML><HEAD></HEAD><BODY><P>Hi Marco,</P><P></P><P>Thanks for your expression.</P><P>I will try and let you know.</P><P>@Enrique @ Priyanka appreciate your quickly response.</P><P>will provide sample data if expression did not work.</P><P></P><P>Regards,</P><P>Ram.</P><P></P><P></P><P></P><P>On Sun, Jan 11, 2015 at 12:42 AM, Marco Wedel &lt;qcwebmaster@qlikview.com&gt;</P></BODY></HTML> Sun, 11 Jan 2015 12:16:52 GMT https://community.qlik.com/t5/QlikView/set-analysis-for-avg-caluclation/m-p/761986#M1039093 2015-01-11T12:16:52Z Re: set analysis for avg caluclation https://community.qlik.com/t5/QlikView/set-analysis-for-avg-caluclation/m-p/761987#M1039094 <HTML><HEAD></HEAD><BODY><P>Thanks all appreciate your help.</P></BODY></HTML> Tue, 13 Jan 2015 16:55:18 GMT https://community.qlik.com/t5/QlikView/set-analysis-for-avg-caluclation/m-p/761987#M1039094 2015-01-13T16:55:18Z