topic Re: how to calculate average value in QlikView

how to calculate average value

francis_gr — Fri, 29 May 2015 19:14:58 GMT

Hi All,

I need to add a column in the sample chart to calculate, for each time, the average value of all the operations done for every office at that time

thanks

Re: how to calculate average value

sunny_talwar — Fri, 29 May 2015 19:35:00 GMT

Not sure what your requirement is, would you be able to tell what your expected output is?

Best,

Sunny

Re: how to calculate average value

sebastiandperei — Fri, 29 May 2015 20:43:08 GMT

Use avg instead of sum

Re: how to calculate average value

MarcoWedel — Fri, 29 May 2015 21:32:49 GMT

Hi,

maybe like this?

hope this helps

regards

Marco

Re: how to calculate average value

francis_gr — Mon, 01 Jun 2015 07:04:48 GMT

Hi Marco!

Thanks for your response.

That's fine but i need a bar chart to show the avearge operations. when i change the chart type from combo chart to bar chart, the average column is over the office`s bars but i neeed to show the average operatios (by time) in a new column.

regards

Re: how to calculate average value

francis_gr — Thu, 04 Jun 2015 17:13:24 GMT

Hi Suni!

Thanks for your reply

As I told Marco, the main problem here is that when i change the chart type from combo chart to bar chart, the average value is over each office`s bar but i neeed to show the average operations done by the two office in that time

please, take a look to the attached file

Regards