topic Re: Aver Expression in QlikView

Aver Expression

brf10043 — Wed, 25 Nov 2020 16:16:04 GMT

Stupid question.

How do I write an average expression for this?

This expression gets me the run line. Now I need an average. I can't seem to get this worked out for some reason.

if(Support_Commitment='SCV Not Available',avg(distinct TOTAL_OUTAGE_DURATION_HOURS),(sum(TotalWSC)+sum(TotalOSC)))

Re: Aver Expression

sunny_talwar — Wed, 17 Oct 2018 01:11:58 GMT

Do you have Support_Commitment as one of the dimensions in the chart where you are using the above expression?

Re: Aver Expression

Anil_Babu_Samineni — Wed, 17 Oct 2018 03:14:47 GMT

If you want on top of Average, You can define like

Avg({<Support_Commitment = {"SCV Not Available"}>} Aggr(if(Support_Commitment='SCV Not Available',avg(distinct TOTAL_OUTAGE_DURATION_HOURS),(sum(TotalWSC)+sum(TotalOSC))), ChartDim1, ChartDim2))