Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
cancel
Showing results for 
Search instead for 
Did you mean: 
jsf_fasoli
Creator II
Creator II

Aggr on a graph - incorrect values

Hello everyone,

I have a KPI that shows average travel days (Días promedio de viaje).

KPI.PNG

Its formula is

formula.PNG

When I take the same expression and remove the date filters to use it in a chart by month year the values are not the same as the ones showed on the KPI (as I expected)

Graph.PNG

The weird thing is when I filter a month the graph shows the same nuber as the KPI. It suggests me an issue with the Key and the dates but I am not finding what exactly can be the problem.

why.PNG

Any help on this would be very appreciated.

Thanks,

Josefina

1 Solution

Accepted Solutions
sunny_talwar

Right, can you add that to the Aggr() function also?

Avg({<....>}Aggr( ....., movil, [Mes Ano]))

View solution in original post

4 Replies
sunny_talwar

May be you need to add Mes Ano as one of the dimension to your aggr function....

jsf_fasoli
Creator II
Creator II

Hi Sunny, thanks for your answer.

The dimension on the graph is mes año

sunny_talwar

Right, can you add that to the Aggr() function also?

Avg({<....>}Aggr( ....., movil, [Mes Ano]))

View solution in original post

jsf_fasoli
Creator II
Creator II

It worked! Thank you so much!