topic Re: Expression not working properly in QlikView https://community.qlik.com/t5/QlikView/Expression-not-working-properly/m-p/962704#M330263 <HTML><HEAD></HEAD><BODY><P>Hello Ashif,</P><P></P><P>Please can you be more specific on what you need. Which expression are you having problems with?</P></BODY></HTML> Mon, 26 Oct 2015 15:56:26 GMT mjm 2015-10-26T15:56:26Z Expression not working properly https://community.qlik.com/t5/QlikView/Expression-not-working-properly/m-p/962703#M330262 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>Expression not working properly.</P><P></P><P>i've attached app. pls check and let me understand the issue.</P><P></P><P>Thanks</P><P>ASHIF</P></BODY></HTML> Mon, 26 Oct 2015 10:41:48 GMT https://community.qlik.com/t5/QlikView/Expression-not-working-properly/m-p/962703#M330262 2015-10-26T10:41:48Z Re: Expression not working properly https://community.qlik.com/t5/QlikView/Expression-not-working-properly/m-p/962704#M330263 <HTML><HEAD></HEAD><BODY><P>Hello Ashif,</P><P></P><P>Please can you be more specific on what you need. Which expression are you having problems with?</P></BODY></HTML> Mon, 26 Oct 2015 15:56:26 GMT https://community.qlik.com/t5/QlikView/Expression-not-working-properly/m-p/962704#M330263 mjm 2015-10-26T15:56:26Z Re: Expression not working properly https://community.qlik.com/t5/QlikView/Expression-not-working-properly/m-p/962705#M330264 <HTML><HEAD></HEAD><BODY><P>Duplicated record?</P></BODY></HTML> Mon, 26 Oct 2015 16:08:55 GMT https://community.qlik.com/t5/QlikView/Expression-not-working-properly/m-p/962705#M330264 maxgro 2015-10-26T16:08:55Z Re: Expression not working properly https://community.qlik.com/t5/QlikView/Expression-not-working-properly/m-p/962706#M330265 <HTML><HEAD></HEAD><BODY><P>Hi Ashif,</P><P></P><P>Maybe your wrong calculation should be something like this?</P><P></P><P>=count(DISTINCT AMOUNT)</P><P></P><P>Please check if that is your correct output <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P><P></P><P>Regards,</P><P>MB</P></BODY></HTML> Mon, 26 Oct 2015 17:01:55 GMT https://community.qlik.com/t5/QlikView/Expression-not-working-properly/m-p/962706#M330265 miguelbraga 2015-10-26T17:01:55Z Re: Expression not working properly https://community.qlik.com/t5/QlikView/Expression-not-working-properly/m-p/962707#M330266 <HTML><HEAD></HEAD><BODY><P>May be use this expression:</P><P></P><P><STRONG>Sum(Aggr(Avg(Qty), AMOUNT, KEY6))</STRONG></P></BODY></HTML> Mon, 26 Oct 2015 17:04:50 GMT https://community.qlik.com/t5/QlikView/Expression-not-working-properly/m-p/962707#M330266 sunny_talwar 2015-10-26T17:04:50Z