Average Formula in Qlik Sense

[#1]

Hi All,

I wan to get average of my this total value. The formula giving me error. What I am doing wrong here?

Avg(sum([VisitA])+sum([VisitB])+sum([VisitC]))

How can I get  the average  in my formula for my measure. Thanks

[sunny_talwar]

You need to use Aggr() function

Avg(Aggr(sum([VisitA])+sum([VisitB])+sum([VisitC]), <Dimension/sHere>))

[#3]

Hi Thanks.

I used the following formula, but its doesn't give me any result.

Avg(Aggr(sum([VisitA])+sum([VisitB])+sum([VisitCt]), <[MDate.autoCalendar.Fiscal Quarter],[MDate.autoCalendar.Fiscal Year]>))

  I used Measure

sum([VisitA])+sum([VisitB])+sum([VisitC]) and

Dimensions ,[MDate.autoCalendar.Fiscal Quarter,] [MDate.autoCalendar.Fiscal Year] for

other chart and trying the same for average.

[sunny_talwar]

<> were just to highlight, not needed in the expression

Avg(Aggr(sum([VisitA])+sum([VisitB])+sum([VisitCt]), [MDate.autoCalendar.Fiscal Quarter],[MDate.autoCalendar.Fiscal Year]))

[#5]

Thanks. the formula gives result same as total. No as average.

[sunny_talwar]

Would you be able to share a screenshot?

[#7]

Left chart has measure with only total formula and same dimension. Right one has average formula same dimension

[sunny_talwar]

Not sure what you are expecting to see when you dimensions are the same? May be you want

Avg([VisitA]) + Avg([VisitB]) + Avg([VisitCt])

[#9]

Actually I need     Avg([Follow-Up]+[Initial Visit]+[Indirect])

This solved my problem. Thanks

[Karim_Khan]

Hi @sunny_talwar  It is working at overall level i.e if we have data for 4 years it will give average of all those years and for getting average of particular year we have to select that year.

What if we want to get different average of each year without any filter selection.

=Avg(Aggr(COUNT(DISTINCT <Expression>,<Dimenssion>]))