topic Incorrect Total showing for one expression in QlikView https://community.qlik.com/t5/QlikView/Incorrect-Total-showing-for-one-expression/m-p/1204606#M387292 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find the attachment for reference. There is simple data related to Call center, a call can be responded, disconnected or IVR disconnect (any one can be possible), when call center has holiday responded+disconnected will be zero, but may be IVR disconnect can have value (customer may call without knowing about holiday and got disconnected in IVR).</P><P></P><P>Now at these kind cases, i have created one extra field.</P><P></P><P>If(Aggr(Sum (RespondedCall)+Sum (DisconnetCall),Date)=0, 0, Sum([IVR DisconnetCall]))</P><P></P><P>For this Total is showing incorrectly, can you please see this and help me.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 19 Oct 2016 06:20:32 GMT sridhar_sigired 2016-10-19T06:20:32Z Incorrect Total showing for one expression https://community.qlik.com/t5/QlikView/Incorrect-Total-showing-for-one-expression/m-p/1204606#M387292 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find the attachment for reference. There is simple data related to Call center, a call can be responded, disconnected or IVR disconnect (any one can be possible), when call center has holiday responded+disconnected will be zero, but may be IVR disconnect can have value (customer may call without knowing about holiday and got disconnected in IVR).</P><P></P><P>Now at these kind cases, i have created one extra field.</P><P></P><P>If(Aggr(Sum (RespondedCall)+Sum (DisconnetCall),Date)=0, 0, Sum([IVR DisconnetCall]))</P><P></P><P>For this Total is showing incorrectly, can you please see this and help me.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 19 Oct 2016 06:20:32 GMT https://community.qlik.com/t5/QlikView/Incorrect-Total-showing-for-one-expression/m-p/1204606#M387292 sridhar_sigired 2016-10-19T06:20:32Z Re: Incorrect Total showing for one expression https://community.qlik.com/t5/QlikView/Incorrect-Total-showing-for-one-expression/m-p/1204607#M387293 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>try</P><P><SPAN style="color: #575757;"><SPAN style="font-size: 10pt;">Sum(Aggr(If(Sum (RespondedCall)+Sum (DisconnetCall) &lt;&gt; 0,Sum([IVR DisconnetCall])),Date</SPAN><SPAN style="font-size: 10pt;">)) </SPAN></SPAN></P><P></P><P><SPAN style="color: #575757; font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="color: #575757; font-size: 10pt;">Antonio</SPAN></P></BODY></HTML> Wed, 19 Oct 2016 06:59:21 GMT https://community.qlik.com/t5/QlikView/Incorrect-Total-showing-for-one-expression/m-p/1204607#M387293 antoniotiman 2016-10-19T06:59:21Z