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