topic Re: Weird issue with average in QlikView

Weird issue with average

Thu, 21 Feb 2013 17:52:36 GMT

Hi All,

I am using the following in my load script(T-SQL)

SELECT OutboundCalls/(OutboundCalls+Inboundcalls) AS Average_Calls

The numbers are in seconds. In my Qlikview table, am using th expression SUM(Average_Calls) as I need to be able to look at this by department or by agent. However, I need to show average for total.But it is not showing average. I have set the "expression total" option to "Average".

Fro example, for the following data, it showing the total as 5.07.

17.81

0.74

22.01

Any idea what is going on?

Re: Weird issue with average

nagaiank — Thu, 21 Feb 2013 18:15:06 GMT

Try to load OutboundCalls and InboundCalls into Qlikview table and calculate the average in Qlikview.

Re: Weird issue with average

Anonymous — Thu, 21 Feb 2013 18:21:01 GMT

Hi,

Please take default as expression total,you will get average value only,if change at avrage it will give average of average value will be come.

Regards

Re: Weird issue with average

Thu, 21 Feb 2013 18:28:52 GMT

I want to do the caluclation in the script to enhance perfromance. So there is no way to do this?

Re: Weird issue with average

Thu, 21 Feb 2013 18:29:13 GMT

If I put the expression total, it sums the numbers

Re: Weird issue with average

Anonymous — Thu, 21 Feb 2013 18:57:41 GMT

Hi,

Can You please send the test application.

Regards

Re: Weird issue with average

erichshiino — Fri, 22 Feb 2013 03:49:08 GMT

I agree with krishnamoorthy. You can't pre-calculate the average, because it would be very complicate to group or summarize it in your dimensions.

You can improve the performance just a bit pre-calculating the sum of inbound and outbound as total_calls.

Then, you use those three fields to calculate the average.

Regards,

Erich