Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siddharth_s2
New Contributor III

Measure not working as desired

Hi all,

I wanted to plot an average monthly sum for a measure.

I used the below formula.

(AVG(

Aggr(Sum(IncidentCount),Month)

))



However, when I break this into a dimension, it does not work. Please see below images.

The first image gives me a false number however filtering into it gives me the right number. i.e. 24.58 is the correct average not 204k.

Where am I going wrong?

Snippet.PNG

1 Solution

Accepted Solutions
agigliotti
Honored Contributor II

Re: Measure not working as desired

maybe this:

AVG( Aggr( Sum(IncidentCount), yourdimension, Month) )

2 Replies
agigliotti
Honored Contributor II

Re: Measure not working as desired

maybe this:

AVG( Aggr( Sum(IncidentCount), yourdimension, Month) )

lironbaram
Honored Contributor II

Re: Measure not working as desired

hi

when using the aggr function

you need to use the desired dimension but also the chart dimensions

in your case

(AVG(

Aggr(Sum(IncidentCount),Month,TierDimension)

))


replace TierDimension with the real dimension field name

Community Browser