Qlik Community

Qlik Sense App Development

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

jsf_fasoli
Contributor 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

Re: Aggr on a graph - incorrect values

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

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

4 Replies

Re: Aggr on a graph - incorrect values

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

jsf_fasoli
Contributor II

Re: Aggr on a graph - incorrect values

Hi Sunny, thanks for your answer.

The dimension on the graph is mes año

Re: Aggr on a graph - incorrect values

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

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

jsf_fasoli
Contributor II

Re: Aggr on a graph - incorrect values

It worked! Thank you so much!

Community Browser