Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

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

View solution in original post

4 Replies

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

Creator II
Creator II

Hi Sunny, thanks for your answer.

The dimension on the graph is mes año

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

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

View solution in original post

Creator II
Creator II

It worked! Thank you so much!