
Re: Average Formula in Qlik Sense
Sunny Talwar Jul 28, 2017 12:43 PM (in response to Saima SM)You need to use Aggr() function
Avg(Aggr(sum([VisitA])+sum([VisitB])+sum([VisitC]), <Dimension/sHere>))

Re: Average Formula in Qlik Sense
Saima SM Jul 28, 2017 1:01 PM (in response to Sunny Talwar )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.

Re: Average Formula in Qlik Sense
Sunny Talwar Jul 28, 2017 1:04 PM (in response to Saima SM)<> 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]))

Re: Average Formula in Qlik Sense
Saima SM Jul 28, 2017 1:08 PM (in response to Sunny Talwar )Thanks. the formula gives result same as total. No as average.

Re: Average Formula in Qlik Sense
Sunny Talwar Jul 28, 2017 1:09 PM (in response to Saima SM)Would you be able to share a screenshot?


Re: Average Formula in Qlik Sense
Sunny Talwar Jul 28, 2017 1:19 PM (in response to Saima SM)Not sure what you are expecting to see when you dimensions are the same? May be you want
Avg([VisitA]) + Avg([VisitB]) + Avg([VisitCt])

Re: Average Formula in Qlik Sense
Saima SM Jul 28, 2017 1:40 PM (in response to Sunny Talwar )Actually I need Avg([FollowUp]+[Initial Visit]+[Indirect])
This solved my problem. Thanks






