topic Trouble getting an average result in a text object in QlikView https://community.qlik.com/t5/QlikView/Trouble-getting-an-average-result-in-a-text-object/m-p/60547#M607473 <HTML><HEAD></HEAD><BODY><P>Hi, I'm having a hard time trying to get in a text object the same average value I get in a simple table objet.</P><P></P><P>The MTTE average result I get in the simple table object is 00:00:57 and I am not able to get it using the expression in the text object of the example I provide attached here.</P><P></P><P>Could you please help me getting the same value in the text object please?</P><P></P><P>Many thanks.</P></BODY></HTML> Tue, 20 Mar 2018 21:42:52 GMT Anonymous 2018-03-20T21:42:52Z Trouble getting an average result in a text object https://community.qlik.com/t5/QlikView/Trouble-getting-an-average-result-in-a-text-object/m-p/60547#M607473 <HTML><HEAD></HEAD><BODY><P>Hi, I'm having a hard time trying to get in a text object the same average value I get in a simple table objet.</P><P></P><P>The MTTE average result I get in the simple table object is 00:00:57 and I am not able to get it using the expression in the text object of the example I provide attached here.</P><P></P><P>Could you please help me getting the same value in the text object please?</P><P></P><P>Many thanks.</P></BODY></HTML> Tue, 20 Mar 2018 21:42:52 GMT https://community.qlik.com/t5/QlikView/Trouble-getting-an-average-result-in-a-text-object/m-p/60547#M607473 Anonymous 2018-03-20T21:42:52Z Re: Trouble getting an average result in a text object https://community.qlik.com/t5/QlikView/Trouble-getting-an-average-result-in-a-text-object/m-p/60548#M607474 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>=time(Avg({&lt;[Classificação do Massivo] = {'Confirmado'}, Alerta -= {'$(vExcludedAlerts)'}&gt;}CriadoIA - MTTE_SLA_Horadeinício))</STRONG></P></BODY></HTML> Wed, 21 Mar 2018 01:46:06 GMT https://community.qlik.com/t5/QlikView/Trouble-getting-an-average-result-in-a-text-object/m-p/60548#M607474 sunny_talwar 2018-03-21T01:46:06Z Re: Trouble getting an average result in a text object https://community.qlik.com/t5/QlikView/Trouble-getting-an-average-result-in-a-text-object/m-p/60549#M607475 <HTML><HEAD></HEAD><BODY><P>It works. Thanks.</P></BODY></HTML> Wed, 21 Mar 2018 11:17:08 GMT https://community.qlik.com/t5/QlikView/Trouble-getting-an-average-result-in-a-text-object/m-p/60549#M607475 Anonymous 2018-03-21T11:17:08Z