Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
malbordio
New Contributor III

Trouble getting an average result in a text object

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.

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.

Could you please help me getting the same value in the text object please?

Many thanks.

1 Solution

Accepted Solutions

Re: Trouble getting an average result in a text object

Try this

=time(Avg({<[Classificação do Massivo] = {'Confirmado'}, Alerta -= {'$(vExcludedAlerts)'}>}CriadoIA - MTTE_SLA_Horadeinício))

View solution in original post

2 Replies

Re: Trouble getting an average result in a text object

Try this

=time(Avg({<[Classificação do Massivo] = {'Confirmado'}, Alerta -= {'$(vExcludedAlerts)'}>}CriadoIA - MTTE_SLA_Horadeinício))

View solution in original post

malbordio
New Contributor III

Re: Trouble getting an average result in a text object

It works. Thanks.