Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
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!