Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
JhonatanS
Contributor
Contributor

Function today() not working

Hi, 

I'm having problems with a average that i want do using a set analysis.

My intention was take a call open and calculate the averege of each ticket pondering by open or closed ticket and a attendant.

So i doed this:


=avg(today()-({<[USUARIO.APELIDO]={'Marcos'},[FT_ATENDIMENTOS.SITUACAO_ATENDIMENTO]={'A'}>}DATA))

Where:
DATA is a date of call open;
[USUARIO.APELIDO] is the attendant;
[FT_ATENDIMENTOS.SITUACAO_ATENDIMENTO] is about the ticket is open(A) or closed(F);

But, the function dont work. I dont now the why. I use the same argument to do anothers KPI's and succed, but this avg not.

Can you help me?

Labels (1)
  • SaaS

2 Replies
rpennacchi
Contributor III
Contributor III

Hi, JhonataS!

This is weird, I think the today function is causing some bug with the set analysis.

But try outter set analysis and I think it will solve your problem:

{<[USUARIO.APELIDO]={'Marcos'},[FT_ATENDIMENTOS.SITUACAO_ATENDIMENTO]={'A'}>} AVG(TODAY()-DATA)

Find me on linkedin:
https://www.linkedin.com/in/rodrigo-pennacchi/
JhonatanS
Contributor
Contributor
Author

ok, thank you very much