topic Re: Average function's not working? in QlikView https://community.qlik.com/t5/QlikView/Average-function-s-not-working/m-p/1255386#M396767 <HTML><HEAD></HEAD><BODY><P>I am sorry, I cannot do that <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Thu, 23 Feb 2017 17:21:07 GMT Anonymous 2017-02-23T17:21:07Z Average function's not working? https://community.qlik.com/t5/QlikView/Average-function-s-not-working/m-p/1255384#M396765 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is there any known issue about the avg function?</P><P></P><P>I have a field that count days per code. The think is that if in a pivot table I have this expression:</P><P></P><P>Avg(distinct Days) and has as Dimensions Name, store, code and Days.</P><P></P><P>The pivot table displays the fields properly, the avg is not correct for a few of them and I don't know why.</P><P></P><P>I have tried to do it manually</P><P></P><P>Sum (distinct days) / Count (distinct Codes)</P><P></P><P>But the results are not well neither.</P><P></P><P>Any idea?</P></BODY></HTML> Thu, 23 Feb 2017 16:41:30 GMT https://community.qlik.com/t5/QlikView/Average-function-s-not-working/m-p/1255384#M396765 Anonymous 2017-02-23T16:41:30Z Re: Average function's not working? https://community.qlik.com/t5/QlikView/Average-function-s-not-working/m-p/1255385#M396766 <HTML><HEAD></HEAD><BODY><P>Can you share a sample to work on? </P></BODY></HTML> Thu, 23 Feb 2017 16:51:32 GMT https://community.qlik.com/t5/QlikView/Average-function-s-not-working/m-p/1255385#M396766 vishsaggi 2017-02-23T16:51:32Z Re: Average function's not working? https://community.qlik.com/t5/QlikView/Average-function-s-not-working/m-p/1255386#M396767 <HTML><HEAD></HEAD><BODY><P>I am sorry, I cannot do that <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Thu, 23 Feb 2017 17:21:07 GMT https://community.qlik.com/t5/QlikView/Average-function-s-not-working/m-p/1255386#M396767 Anonymous 2017-02-23T17:21:07Z Re: Average function's not working? https://community.qlik.com/t5/QlikView/Average-function-s-not-working/m-p/1255387#M396768 <HTML><HEAD></HEAD><BODY><P>You can scramble your data and upload like mentioned here:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-1290">Preparing examples for Upload - Reduction and Data Scrambling</A></P></BODY></HTML> Thu, 23 Feb 2017 17:22:15 GMT https://community.qlik.com/t5/QlikView/Average-function-s-not-working/m-p/1255387#M396768 vishsaggi 2017-02-23T17:22:15Z